DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on FND_MESSAGE

Line 68: fnd_message.set_name('WIP', 'WIP_PURGE_ROWS');

64: p_purge_rec in out nocopy purge_report_type) is
65:
66: begin
67: if ( p_num_rows > 0 ) then
68: fnd_message.set_name('WIP', 'WIP_PURGE_ROWS');
69: fnd_message.set_token('NUMBER', to_char(p_num_rows));
70: p_purge_rec.info := fnd_message.get;
71: append_report(p_purge_rec, p_option);
72: end if;

Line 69: fnd_message.set_token('NUMBER', to_char(p_num_rows));

65:
66: begin
67: if ( p_num_rows > 0 ) then
68: fnd_message.set_name('WIP', 'WIP_PURGE_ROWS');
69: fnd_message.set_token('NUMBER', to_char(p_num_rows));
70: p_purge_rec.info := fnd_message.get;
71: append_report(p_purge_rec, p_option);
72: end if;
73: end construct_report_content;

Line 70: p_purge_rec.info := fnd_message.get;

66: begin
67: if ( p_num_rows > 0 ) then
68: fnd_message.set_name('WIP', 'WIP_PURGE_ROWS');
69: fnd_message.set_token('NUMBER', to_char(p_num_rows));
70: p_purge_rec.info := fnd_message.get;
71: append_report(p_purge_rec, p_option);
72: end if;
73: end construct_report_content;
74:

Line 103: fnd_message.set_name('WIP', 'WIP_PURGE_ROWS');

99: rollback to wictpg_sp;
100: end if;
101:
102: if (x_num_rows > 0) then
103: fnd_message.set_name('WIP', 'WIP_PURGE_ROWS');
104: fnd_message.set_token('NUMBER', to_char(x_num_rows));
105: x_message := fnd_message.get;
106: x_purge_rec := p_purge_rec;
107: x_purge_rec.info := x_message;

Line 104: fnd_message.set_token('NUMBER', to_char(x_num_rows));

100: end if;
101:
102: if (x_num_rows > 0) then
103: fnd_message.set_name('WIP', 'WIP_PURGE_ROWS');
104: fnd_message.set_token('NUMBER', to_char(x_num_rows));
105: x_message := fnd_message.get;
106: x_purge_rec := p_purge_rec;
107: x_purge_rec.info := x_message;
108: append_report(x_purge_rec,p_option);

Line 105: x_message := fnd_message.get;

101:
102: if (x_num_rows > 0) then
103: fnd_message.set_name('WIP', 'WIP_PURGE_ROWS');
104: fnd_message.set_token('NUMBER', to_char(x_num_rows));
105: x_message := fnd_message.get;
106: x_purge_rec := p_purge_rec;
107: x_purge_rec.info := x_message;
108: append_report(x_purge_rec,p_option);
109: end if;

Line 125: fnd_message.set_name('WIP', 'WIP_PURGE_ROWS');

121: num_rows in number) is
122: x_purge_rec purge_report_type;
123: begin
124:
125: fnd_message.set_name('WIP', 'WIP_PURGE_ROWS');
126: fnd_message.set_token('NUMBER', to_char(num_rows));
127: x_purge_rec := p_purge_rec;
128: x_purge_rec.info := fnd_message.get;
129: append_report(x_purge_rec,p_option);

Line 126: fnd_message.set_token('NUMBER', to_char(num_rows));

122: x_purge_rec purge_report_type;
123: begin
124:
125: fnd_message.set_name('WIP', 'WIP_PURGE_ROWS');
126: fnd_message.set_token('NUMBER', to_char(num_rows));
127: x_purge_rec := p_purge_rec;
128: x_purge_rec.info := fnd_message.get;
129: append_report(x_purge_rec,p_option);
130:

Line 128: x_purge_rec.info := fnd_message.get;

124:
125: fnd_message.set_name('WIP', 'WIP_PURGE_ROWS');
126: fnd_message.set_token('NUMBER', to_char(num_rows));
127: x_purge_rec := p_purge_rec;
128: x_purge_rec.info := fnd_message.get;
129: append_report(x_purge_rec,p_option);
130:
131: end before_append_report;
132:

Line 620: fnd_message.set_name('WIP', 'WIP_TRANSACTIONS_PURGE_ERROR');

616: x_purge_rec.line_code := p_purge_request.line_code;
617:
618:
619: -- verify that no other schedules exists
620: fnd_message.set_name('WIP', 'WIP_TRANSACTIONS_PURGE_ERROR');
621: x_purge_rec.info := fnd_message.get;
622: x_purge_rec.table_name := 'WIP_MOVE_TXN_ALLOCATIONS';
623: SELECT COUNT(*) into l_num_rows
624: FROM DUAL WHERE EXISTS (

Line 621: x_purge_rec.info := fnd_message.get;

617:
618:
619: -- verify that no other schedules exists
620: fnd_message.set_name('WIP', 'WIP_TRANSACTIONS_PURGE_ERROR');
621: x_purge_rec.info := fnd_message.get;
622: x_purge_rec.table_name := 'WIP_MOVE_TXN_ALLOCATIONS';
623: SELECT COUNT(*) into l_num_rows
624: FROM DUAL WHERE EXISTS (
625: SELECT out_wmta.transaction_id

Line 871: fnd_message.set_name('WIP', 'WIP_TRANSACTIONS_PURGE_ERROR');

867: x_purge_rec.line_code := p_purge_request.line_code;
868:
869:
870: -- verify that no other schedules exists
871: fnd_message.set_name('WIP', 'WIP_TRANSACTIONS_PURGE_ERROR');
872: x_purge_rec.info := fnd_message.get;
873: x_purge_rec.table_name := 'WIP_TXN_ALLOCATIONS';
874:
875: SELECT COUNT(*) into l_num_rows

Line 872: x_purge_rec.info := fnd_message.get;

868:
869:
870: -- verify that no other schedules exists
871: fnd_message.set_name('WIP', 'WIP_TRANSACTIONS_PURGE_ERROR');
872: x_purge_rec.info := fnd_message.get;
873: x_purge_rec.table_name := 'WIP_TXN_ALLOCATIONS';
874:
875: SELECT COUNT(*) into l_num_rows
876: FROM DUAL WHERE EXISTS (

Line 1068: fnd_message.set_name('WIP', 'WIP_PERIOD_BALANCES_EXIST');

1064: x_purge_rec.line_code := p_purge_request.line_code;
1065:
1066:
1067: -- verify no period balance activity
1068: fnd_message.set_name('WIP', 'WIP_PERIOD_BALANCES_EXIST');
1069: x_purge_rec.info := fnd_message.get;
1070: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';
1071:
1072: /* Fixing bug 935919. The following sql is introduced to replace the earlier one because

Line 1069: x_purge_rec.info := fnd_message.get;

1065:
1066:
1067: -- verify no period balance activity
1068: fnd_message.set_name('WIP', 'WIP_PERIOD_BALANCES_EXIST');
1069: x_purge_rec.info := fnd_message.get;
1070: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';
1071:
1072: /* Fixing bug 935919. The following sql is introduced to replace the earlier one because
1073: the checking should be done to see whether the sum of (IN - OUT NOCOPY - VAR) of each cost

Line 1103: fnd_message.set_name('WIP', 'WIP_PURGE_FOREIGN_KEY');

1099: end if;
1100:
1101:
1102: -- check for foreign key references
1103: fnd_message.set_name('WIP', 'WIP_PURGE_FOREIGN_KEY');
1104: fnd_message.set_token('TABLE', 'WIP_DISCRETE_JOBS', TRUE);
1105: x_purge_rec.info := fnd_message.get;
1106:
1107: x_purge_rec.table_name := 'CST_STD_COST_ADJ_VALUES';

Line 1104: fnd_message.set_token('TABLE', 'WIP_DISCRETE_JOBS', TRUE);

1100:
1101:
1102: -- check for foreign key references
1103: fnd_message.set_name('WIP', 'WIP_PURGE_FOREIGN_KEY');
1104: fnd_message.set_token('TABLE', 'WIP_DISCRETE_JOBS', TRUE);
1105: x_purge_rec.info := fnd_message.get;
1106:
1107: x_purge_rec.table_name := 'CST_STD_COST_ADJ_VALUES';
1108:

Line 1105: x_purge_rec.info := fnd_message.get;

1101:
1102: -- check for foreign key references
1103: fnd_message.set_name('WIP', 'WIP_PURGE_FOREIGN_KEY');
1104: fnd_message.set_token('TABLE', 'WIP_DISCRETE_JOBS', TRUE);
1105: x_purge_rec.info := fnd_message.get;
1106:
1107: x_purge_rec.table_name := 'CST_STD_COST_ADJ_VALUES';
1108:
1109: SELECT COUNT(*)

Line 1461: fnd_message.set_name('WIP', 'WIP_SERIAL_FOREIGN_KEY');

1457: end if;
1458:
1459: if x_num_rows > 0 then
1460: x_purge_rec.table_name := 'MTL_SERIAL_NUMBERS';
1461: fnd_message.set_name('WIP', 'WIP_SERIAL_FOREIGN_KEY');
1462: x_purge_rec.info := fnd_message.get;
1463: append_report(x_purge_rec, p_option);
1464: end if;
1465:

Line 1462: x_purge_rec.info := fnd_message.get;

1458:
1459: if x_num_rows > 0 then
1460: x_purge_rec.table_name := 'MTL_SERIAL_NUMBERS';
1461: fnd_message.set_name('WIP', 'WIP_SERIAL_FOREIGN_KEY');
1462: x_purge_rec.info := fnd_message.get;
1463: append_report(x_purge_rec, p_option);
1464: end if;
1465:
1466: x_purge_rec.info_type := ROWS_AFFECTED;

Line 1995: fnd_message.set_name('WIP', 'WIP_PERIOD_BALANCES_EXIST');

1991: x_purge_rec.entity_name := p_purge_request.wip_entity_name;
1992: x_purge_rec.line_code := p_purge_request.line_code;
1993:
1994: -- set message; verify no period balance activity
1995: fnd_message.set_name('WIP', 'WIP_PERIOD_BALANCES_EXIST');
1996: x_purge_rec.info := fnd_message.get;
1997:
1998: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';
1999:

Line 1996: x_purge_rec.info := fnd_message.get;

1992: x_purge_rec.line_code := p_purge_request.line_code;
1993:
1994: -- set message; verify no period balance activity
1995: fnd_message.set_name('WIP', 'WIP_PERIOD_BALANCES_EXIST');
1996: x_purge_rec.info := fnd_message.get;
1997:
1998: x_purge_rec.table_name := 'WIP_PERIOD_BALANCES';
1999:
2000: /* Fixing bug 935919. The following sql is introduced to replace the earlier one because

Line 2038: fnd_message.set_name('WIP', 'WIP_PURGE_FOREIGN_KEY');

2034: end if;
2035: l_num_rows := 0;
2036:
2037: -- reset message; check for foreign key references
2038: fnd_message.set_name('WIP', 'WIP_PURGE_FOREIGN_KEY');
2039: fnd_message.set_token('TABLE', 'WIP_REPETITIVE_SCHEDULES', TRUE);
2040: x_purge_rec.info := fnd_message.get;
2041:
2042: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ALL';

Line 2039: fnd_message.set_token('TABLE', 'WIP_REPETITIVE_SCHEDULES', TRUE);

2035: l_num_rows := 0;
2036:
2037: -- reset message; check for foreign key references
2038: fnd_message.set_name('WIP', 'WIP_PURGE_FOREIGN_KEY');
2039: fnd_message.set_token('TABLE', 'WIP_REPETITIVE_SCHEDULES', TRUE);
2040: x_purge_rec.info := fnd_message.get;
2041:
2042: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ALL';
2043: SELECT COUNT(*) into l_num_rows

Line 2040: x_purge_rec.info := fnd_message.get;

2036:
2037: -- reset message; check for foreign key references
2038: fnd_message.set_name('WIP', 'WIP_PURGE_FOREIGN_KEY');
2039: fnd_message.set_token('TABLE', 'WIP_REPETITIVE_SCHEDULES', TRUE);
2040: x_purge_rec.info := fnd_message.get;
2041:
2042: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ALL';
2043: SELECT COUNT(*) into l_num_rows
2044: FROM DUAL

Line 2117: fnd_message.set_name('WIP', 'WIP_ALLOCATIONS_EXIST');

2113: end if;
2114: l_num_rows := 0;
2115:
2116: -- reset message; check for allocations
2117: fnd_message.set_name('WIP', 'WIP_ALLOCATIONS_EXIST');
2118: x_purge_rec.info := fnd_message.get;
2119:
2120: x_purge_rec.table_name := 'MTL_MATERIAL_TXN_ALLOCATIONS';
2121: SELECT COUNT(*) into l_num_rows

Line 2118: x_purge_rec.info := fnd_message.get;

2114: l_num_rows := 0;
2115:
2116: -- reset message; check for allocations
2117: fnd_message.set_name('WIP', 'WIP_ALLOCATIONS_EXIST');
2118: x_purge_rec.info := fnd_message.get;
2119:
2120: x_purge_rec.table_name := 'MTL_MATERIAL_TXN_ALLOCATIONS';
2121: SELECT COUNT(*) into l_num_rows
2122: FROM DUAL