DBA Data[Home] [Help]

APPS.CSTPPCIT dependencies on FND_MESSAGE

Line 59: FND_MESSAGE.set_name('BOM', 'CST_PAC_CG_INVALID');

55:
56: IF (l_count = 0) THEN
57: l_err_num := 999;
58: l_err_code := 'CST_PAC_CG_INVALID';
59: FND_MESSAGE.set_name('BOM', 'CST_PAC_CG_INVALID');
60: l_err_msg := FND_MESSAGE.Get;
61: raise process_error;
62: END IF;
63:

Line 60: l_err_msg := FND_MESSAGE.Get;

56: IF (l_count = 0) THEN
57: l_err_num := 999;
58: l_err_code := 'CST_PAC_CG_INVALID';
59: FND_MESSAGE.set_name('BOM', 'CST_PAC_CG_INVALID');
60: l_err_msg := FND_MESSAGE.Get;
61: raise process_error;
62: END IF;
63:
64: l_stmt_num := 20;

Line 83: FND_MESSAGE.set_name('BOM', 'CST_PAC_CT_INVALID');

79:
80: IF (l_count = 0) THEN
81: l_err_num := 999;
82: l_err_code := 'CST_PAC_CT_INVALID';
83: FND_MESSAGE.set_name('BOM', 'CST_PAC_CT_INVALID');
84: l_err_msg := FND_MESSAGE.Get;
85: raise process_error;
86: END IF;
87:

Line 84: l_err_msg := FND_MESSAGE.Get;

80: IF (l_count = 0) THEN
81: l_err_num := 999;
82: l_err_code := 'CST_PAC_CT_INVALID';
83: FND_MESSAGE.set_name('BOM', 'CST_PAC_CT_INVALID');
84: l_err_msg := FND_MESSAGE.Get;
85: raise process_error;
86: END IF;
87:
88: l_stmt_num := 40;

Line 113: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ORG');

109:
110: IF (l_count = 0) THEN
111: l_err_num := 999;
112: l_err_code := 'CST_NO_TXN_INVALID_ORG';
113: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ORG');
114: l_err_msg := FND_MESSAGE.Get;
115: raise process_error;
116: END IF;
117:

Line 114: l_err_msg := FND_MESSAGE.Get;

110: IF (l_count = 0) THEN
111: l_err_num := 999;
112: l_err_code := 'CST_NO_TXN_INVALID_ORG';
113: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ORG');
114: l_err_msg := FND_MESSAGE.Get;
115: raise process_error;
116: END IF;
117:
118: l_stmt_num := 60;

Line 137: FND_MESSAGE.set_name('BOM', 'CST_PAC_CLOSE_PERIOD');

133:
134: IF (l_open_flag = 'N') THEN
135: l_err_num := 999;
136: l_err_code := 'CST_PAC_CLOSE_PERIOD';
137: FND_MESSAGE.set_name('BOM', 'CST_PAC_CLOSE_PERIOD');
138: l_err_msg := FND_MESSAGE.Get;
139: raise process_error;
140: END IF;
141: END IF;

Line 138: l_err_msg := FND_MESSAGE.Get;

134: IF (l_open_flag = 'N') THEN
135: l_err_num := 999;
136: l_err_code := 'CST_PAC_CLOSE_PERIOD';
137: FND_MESSAGE.set_name('BOM', 'CST_PAC_CLOSE_PERIOD');
138: l_err_msg := FND_MESSAGE.Get;
139: raise process_error;
140: END IF;
141: END IF;
142:

Line 155: FND_MESSAGE.set_name('BOM', 'CST_PAC_TXN_DATE_INVALID');

151:
152: IF (l_count = 0) THEN
153: l_err_num := 999;
154: l_err_code := 'CST_PAC_TXN_DATE_INVALID';
155: FND_MESSAGE.set_name('BOM', 'CST_PAC_TXN_DATE_INVALID');
156: l_err_msg := FND_MESSAGE.Get;
157: raise process_error;
158: END IF;
159:

Line 156: l_err_msg := FND_MESSAGE.Get;

152: IF (l_count = 0) THEN
153: l_err_num := 999;
154: l_err_code := 'CST_PAC_TXN_DATE_INVALID';
155: FND_MESSAGE.set_name('BOM', 'CST_PAC_TXN_DATE_INVALID');
156: l_err_msg := FND_MESSAGE.Get;
157: raise process_error;
158: END IF;
159:
160:

Line 182: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');

178: END IF;
179: IF (l_count > 0) THEN
180: l_err_num := 999;
181: l_err_code := 'CST_NO_TXN_INVALID_ACCOUNT';
182: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');
183: l_err_msg := FND_MESSAGE.Get;
184: raise process_error;
185: END IF;
186:

Line 183: l_err_msg := FND_MESSAGE.Get;

179: IF (l_count > 0) THEN
180: l_err_num := 999;
181: l_err_code := 'CST_NO_TXN_INVALID_ACCOUNT';
182: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');
183: l_err_msg := FND_MESSAGE.Get;
184: raise process_error;
185: END IF;
186:
187: /* Validate the consistency of data

Line 214: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_COST_CHANGE');

210: AND percentage_change IS NULL AND value_change IS NULL;
211: IF (l_count <> l_num_details OR l_sum_new_cost <> i_new_avg_cost) THEN
212: l_err_num := 999;
213: l_err_code := 'CST_NO_TXN_INVALID_COST_CHANGE';
214: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_COST_CHANGE');
215: l_err_msg := FND_MESSAGE.Get;
216: raise process_error;
217: END IF;
218: ELSIF ( i_new_avg_cost IS NULL AND i_per_change IS NOT NULL AND i_val_change IS NULL ) THEN

Line 215: l_err_msg := FND_MESSAGE.Get;

211: IF (l_count <> l_num_details OR l_sum_new_cost <> i_new_avg_cost) THEN
212: l_err_num := 999;
213: l_err_code := 'CST_NO_TXN_INVALID_COST_CHANGE';
214: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_COST_CHANGE');
215: l_err_msg := FND_MESSAGE.Get;
216: raise process_error;
217: END IF;
218: ELSIF ( i_new_avg_cost IS NULL AND i_per_change IS NOT NULL AND i_val_change IS NULL ) THEN
219: l_stmt_num := 120;

Line 229: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_COST_CHANGE');

225: AND NVL(percentage_change,-999) >= -100 AND value_change IS NULL;
226: IF (l_count <> l_num_details) THEN
227: l_err_num := 999;
228: l_err_code := 'CST_NO_TXN_INVALID_COST_CHANGE';
229: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_COST_CHANGE');
230: l_err_msg := FND_MESSAGE.Get;
231: raise process_error;
232: END IF;
233: ELSIF ( i_new_avg_cost IS NULL AND i_per_change IS NULL AND i_val_change IS NOT NULL ) THEN

Line 230: l_err_msg := FND_MESSAGE.Get;

226: IF (l_count <> l_num_details) THEN
227: l_err_num := 999;
228: l_err_code := 'CST_NO_TXN_INVALID_COST_CHANGE';
229: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_COST_CHANGE');
230: l_err_msg := FND_MESSAGE.Get;
231: raise process_error;
232: END IF;
233: ELSIF ( i_new_avg_cost IS NULL AND i_per_change IS NULL AND i_val_change IS NOT NULL ) THEN
234: l_stmt_num := 130;

Line 244: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_COST_CHANGE');

240: AND percentage_change IS NULL AND value_change IS NOT NULL;
241: IF (l_count <> l_num_details OR l_sum_value_change <> i_val_change) THEN
242: l_err_num := 999;
243: l_err_code := 'CST_NO_TXN_INVALID_COST_CHANGE';
244: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_COST_CHANGE');
245: l_err_msg := FND_MESSAGE.Get;
246: raise process_error;
247: END IF;
248: ELSE

Line 245: l_err_msg := FND_MESSAGE.Get;

241: IF (l_count <> l_num_details OR l_sum_value_change <> i_val_change) THEN
242: l_err_num := 999;
243: l_err_code := 'CST_NO_TXN_INVALID_COST_CHANGE';
244: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_COST_CHANGE');
245: l_err_msg := FND_MESSAGE.Get;
246: raise process_error;
247: END IF;
248: ELSE
249: l_err_num := 999;

Line 251: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_COST_CHANGE');

247: END IF;
248: ELSE
249: l_err_num := 999;
250: l_err_code := 'CST_NO_TXN_INVALID_COST_CHANGE';
251: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_COST_CHANGE');
252: l_err_msg := FND_MESSAGE.Get;
253: raise process_error;
254: END IF;
255:

Line 252: l_err_msg := FND_MESSAGE.Get;

248: ELSE
249: l_err_num := 999;
250: l_err_code := 'CST_NO_TXN_INVALID_COST_CHANGE';
251: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_COST_CHANGE');
252: l_err_msg := FND_MESSAGE.Get;
253: raise process_error;
254: END IF;
255:
256: l_stmt_num := 140;

Line 534: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');

530: (l_cost_element.cost_element_id = 4 AND i_osp_accnt IS NULL) OR
531: (l_cost_element.cost_element_id = 5 AND i_ovhd_accnt IS NULL)) THEN
532: -- Error occured
533:
534: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');
535: l_err_num := 999;
536: l_err_code := 'Invalid accounts.';
537: l_err_msg := FND_MESSAGE.Get;
538:

Line 537: l_err_msg := FND_MESSAGE.Get;

533:
534: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');
535: l_err_num := 999;
536: l_err_code := 'Invalid accounts.';
537: l_err_msg := FND_MESSAGE.Get;
538:
539: RAISE process_error;
540: END IF;
541:

Line 614: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');

610: */
611: ELSE
612:
613: IF (i_mat_accnt is null) THEN
614: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');
615: l_err_num := 999;
616: l_err_code := 'Invalid accounts.';
617: l_err_msg := FND_MESSAGE.Get;
618:

Line 617: l_err_msg := FND_MESSAGE.Get;

613: IF (i_mat_accnt is null) THEN
614: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');
615: l_err_num := 999;
616: l_err_code := 'Invalid accounts.';
617: l_err_msg := FND_MESSAGE.Get;
618:
619: RAISE process_error;
620: END IF;
621: