eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_SLA_UTL_PROCESSING_PKG dependencies on FND_MESSAGE

Line 77: Fnd_message.set_name('FND','FND_GENERIC_MESSAGE');

73: trace(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
74: trace(C_STATE_LEVEL, l_procedure_name, 'g_CurrentEventId='||g_CurrentEventId);
75: fnd_file.put_line(fnd_file.log, 'ERROR: '||p_error_message);
76: IF (g_CurrentEventId IS NOT NULL) THEN
77: Fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
78: Fnd_Message.Set_Token('MESSAGE',p_error_message);
79: psa_bc_xla_pvt.psa_xla_error
80: (
81: p_message_code => 'FND_GENERIC_MESSAGE',

Line 78: Fnd_Message.Set_Token('MESSAGE',p_error_message);

74: trace(C_STATE_LEVEL, l_procedure_name, 'g_CurrentEventId='||g_CurrentEventId);
75: fnd_file.put_line(fnd_file.log, 'ERROR: '||p_error_message);
76: IF (g_CurrentEventId IS NOT NULL) THEN
77: Fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
78: Fnd_Message.Set_Token('MESSAGE',p_error_message);
79: psa_bc_xla_pvt.psa_xla_error
80: (
81: p_message_code => 'FND_GENERIC_MESSAGE',
82: p_event_id => g_CurrentEventId

Line 169: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

165: RETURN (l_bank_rec.cash_bank_natural_account);
166: EXCEPTION
167: WHEN OTHERS THEN
168: l_error_code := c_FAILURE;
169: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
170: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
171: l_error_desc := fnd_message.get;
172: stack_error (l_procedure_name, 'FINAL', l_error_desc);
173: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||l_error_desc);

Line 170: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

166: EXCEPTION
167: WHEN OTHERS THEN
168: l_error_code := c_FAILURE;
169: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
170: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
171: l_error_desc := fnd_message.get;
172: stack_error (l_procedure_name, 'FINAL', l_error_desc);
173: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||l_error_desc);
174: RETURN (l_bank_rec.cash_bank_natural_account);

Line 171: l_error_desc := fnd_message.get;

167: WHEN OTHERS THEN
168: l_error_code := c_FAILURE;
169: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
170: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
171: l_error_desc := fnd_message.get;
172: stack_error (l_procedure_name, 'FINAL', l_error_desc);
173: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||l_error_desc);
174: RETURN (l_bank_rec.cash_bank_natural_account);
175: END;

Line 235: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

231: l_bank_rec.cash_bank_account_ccid := NULL;
232: l_coaid := NULL;
233: WHEN OTHERS THEN
234: p_error_code := c_FAILURE;
235: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
236: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
237: p_error_desc := fnd_message.get;
238: stack_error (l_procedure_name, 'SELECT_ce_gl_accounts_ccid', p_error_desc);
239: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_ce_gl_accounts_ccid:'||p_error_desc);

Line 236: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

232: l_coaid := NULL;
233: WHEN OTHERS THEN
234: p_error_code := c_FAILURE;
235: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
236: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
237: p_error_desc := fnd_message.get;
238: stack_error (l_procedure_name, 'SELECT_ce_gl_accounts_ccid', p_error_desc);
239: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_ce_gl_accounts_ccid:'||p_error_desc);
240: END;

Line 237: p_error_desc := fnd_message.get;

233: WHEN OTHERS THEN
234: p_error_code := c_FAILURE;
235: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
236: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
237: p_error_desc := fnd_message.get;
238: stack_error (l_procedure_name, 'SELECT_ce_gl_accounts_ccid', p_error_desc);
239: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_ce_gl_accounts_ccid:'||p_error_desc);
240: END;
241:

Line 262: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

258: trace(C_STATE_LEVEL, l_procedure_name, 'accounting_seg_num='||l_accounting_seg_num);
259: EXCEPTION
260: WHEN OTHERS THEN
261: p_error_code := c_FAILURE;
262: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
263: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
264: p_error_desc := fnd_message.get;
265: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
266: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);

Line 263: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

259: EXCEPTION
260: WHEN OTHERS THEN
261: p_error_code := c_FAILURE;
262: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
263: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
264: p_error_desc := fnd_message.get;
265: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
266: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);
267: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

Line 264: p_error_desc := fnd_message.get;

260: WHEN OTHERS THEN
261: p_error_code := c_FAILURE;
262: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
263: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
264: p_error_desc := fnd_message.get;
265: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
266: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);
267: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
268: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||

Line 267: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

263: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
264: p_error_desc := fnd_message.get;
265: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
266: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);
267: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
268: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||
269: 'Accounting Segment is not Defined for the COA '||l_coaid);
270: p_error_desc := fnd_message.get;
271: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);

Line 268: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||

264: p_error_desc := fnd_message.get;
265: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
266: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);
267: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
268: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||
269: 'Accounting Segment is not Defined for the COA '||l_coaid);
270: p_error_desc := fnd_message.get;
271: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
272: END;

Line 270: p_error_desc := fnd_message.get;

266: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);
267: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
268: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||
269: 'Accounting Segment is not Defined for the COA '||l_coaid);
270: p_error_desc := fnd_message.get;
271: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
272: END;
273: END IF;
274:

Line 327: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

323: trace(C_STATE_LEVEL, l_procedure_name, 'END');
324: EXCEPTION
325: WHEN OTHERS THEN
326: p_error_code := c_FAILURE;
327: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
328: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
329: p_error_desc := fnd_message.get;
330: stack_error (l_procedure_name, 'FINAL', p_error_desc);
331: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 328: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

324: EXCEPTION
325: WHEN OTHERS THEN
326: p_error_code := c_FAILURE;
327: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
328: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
329: p_error_desc := fnd_message.get;
330: stack_error (l_procedure_name, 'FINAL', p_error_desc);
331: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
332: END;

Line 329: p_error_desc := fnd_message.get;

325: WHEN OTHERS THEN
326: p_error_code := c_FAILURE;
327: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
328: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
329: p_error_desc := fnd_message.get;
330: stack_error (l_procedure_name, 'FINAL', p_error_desc);
331: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
332: END;
333:

Line 370: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

366: l_org_rec.dit_flag := NULL;
367: l_org_rec.cash_account := NULL;
368: WHEN OTHERS THEN
369: p_error_code := c_FAILURE;
370: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
371: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
372: p_error_desc := fnd_message.get;
373: stack_error (l_procedure_name, 'SELECT_fv_operating_units_all', p_error_desc);
374: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_operating_units_all:'||p_error_desc);

Line 371: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

367: l_org_rec.cash_account := NULL;
368: WHEN OTHERS THEN
369: p_error_code := c_FAILURE;
370: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
371: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
372: p_error_desc := fnd_message.get;
373: stack_error (l_procedure_name, 'SELECT_fv_operating_units_all', p_error_desc);
374: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_operating_units_all:'||p_error_desc);
375: END;

Line 372: p_error_desc := fnd_message.get;

368: WHEN OTHERS THEN
369: p_error_code := c_FAILURE;
370: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
371: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
372: p_error_desc := fnd_message.get;
373: stack_error (l_procedure_name, 'SELECT_fv_operating_units_all', p_error_desc);
374: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_operating_units_all:'||p_error_desc);
375: END;
376: IF (p_error_code = c_SUCCESS) THEN

Line 389: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

385: trace(C_STATE_LEVEL, l_procedure_name, 'END');
386: EXCEPTION
387: WHEN OTHERS THEN
388: p_error_code := c_FAILURE;
389: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
390: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
391: p_error_desc := fnd_message.get;
392: stack_error (l_procedure_name, 'FINAL', p_error_desc);
393: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 390: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

386: EXCEPTION
387: WHEN OTHERS THEN
388: p_error_code := c_FAILURE;
389: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
390: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
391: p_error_desc := fnd_message.get;
392: stack_error (l_procedure_name, 'FINAL', p_error_desc);
393: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
394: END;

Line 391: p_error_desc := fnd_message.get;

387: WHEN OTHERS THEN
388: p_error_code := c_FAILURE;
389: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
390: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
391: p_error_desc := fnd_message.get;
392: stack_error (l_procedure_name, 'FINAL', p_error_desc);
393: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
394: END;
395:

Line 457: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

453:
454: EXCEPTION
455: WHEN OTHERS THEN
456: p_error_code := c_FAILURE;
457: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
458: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
459: p_error_desc := fnd_message.get;
460: stack_error (l_procedure_name, 'FINAL', p_error_desc);
461: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 458: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

454: EXCEPTION
455: WHEN OTHERS THEN
456: p_error_code := c_FAILURE;
457: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
458: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
459: p_error_desc := fnd_message.get;
460: stack_error (l_procedure_name, 'FINAL', p_error_desc);
461: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
462: END get_segment_values;

Line 459: p_error_desc := fnd_message.get;

455: WHEN OTHERS THEN
456: p_error_code := c_FAILURE;
457: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
458: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
459: p_error_desc := fnd_message.get;
460: stack_error (l_procedure_name, 'FINAL', p_error_desc);
461: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
462: END get_segment_values;
463:

Line 509: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

505: trace(C_STATE_LEVEL, l_procedure_name, 'chart_of_accounts_id='||l_ledger_rec.coaid);
506: EXCEPTION
507: WHEN OTHERS THEN
508: p_error_code := c_FAILURE;
509: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
510: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
511: p_error_desc := fnd_message.get;
512: stack_error (l_procedure_name, 'SELECT_GL_LEDGERS', p_error_desc);
513: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_GL_LEDGERS:'||p_error_desc);

Line 510: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

506: EXCEPTION
507: WHEN OTHERS THEN
508: p_error_code := c_FAILURE;
509: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
510: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
511: p_error_desc := fnd_message.get;
512: stack_error (l_procedure_name, 'SELECT_GL_LEDGERS', p_error_desc);
513: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_GL_LEDGERS:'||p_error_desc);
514: END;

Line 511: p_error_desc := fnd_message.get;

507: WHEN OTHERS THEN
508: p_error_code := c_FAILURE;
509: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
510: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
511: p_error_desc := fnd_message.get;
512: stack_error (l_procedure_name, 'SELECT_GL_LEDGERS', p_error_desc);
513: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_GL_LEDGERS:'||p_error_desc);
514: END;
515:

Line 539: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

535: trace(C_STATE_LEVEL, l_procedure_name, 'accounting_seg_name='||l_ledger_rec.accounting_seg_name);
536: EXCEPTION
537: WHEN OTHERS THEN
538: p_error_code := c_FAILURE;
539: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
540: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
541: p_error_desc := fnd_message.get;
542: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
543: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);

Line 540: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

536: EXCEPTION
537: WHEN OTHERS THEN
538: p_error_code := c_FAILURE;
539: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
540: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
541: p_error_desc := fnd_message.get;
542: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
543: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);
544: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

Line 541: p_error_desc := fnd_message.get;

537: WHEN OTHERS THEN
538: p_error_code := c_FAILURE;
539: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
540: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
541: p_error_desc := fnd_message.get;
542: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
543: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);
544: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
545: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||

Line 544: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

540: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
541: p_error_desc := fnd_message.get;
542: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
543: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);
544: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
545: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||
546: 'Accounting Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
547: p_error_desc := fnd_message.get;
548: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);

Line 545: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||

541: p_error_desc := fnd_message.get;
542: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
543: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);
544: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
545: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||
546: 'Accounting Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
547: p_error_desc := fnd_message.get;
548: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
549: l_ledger_rec.balancing_seg_num := NULL;

Line 547: p_error_desc := fnd_message.get;

543: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT):'||p_error_desc);
544: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
545: fnd_message.set_token('MESSAGE' , 'Error in Getting Accounting Segment.'||CRLF||
546: 'Accounting Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
547: p_error_desc := fnd_message.get;
548: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_ACCOUNT)', p_error_desc);
549: l_ledger_rec.balancing_seg_num := NULL;
550: l_ledger_rec.balancing_seg_name := NULL;
551: END;

Line 577: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

573: trace(C_STATE_LEVEL, l_procedure_name, 'balancing_segment_name='||l_ledger_rec.balancing_seg_name);
574: EXCEPTION
575: WHEN OTHERS THEN
576: p_error_code := c_FAILURE;
577: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
578: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
579: p_error_desc := fnd_message.get;
580: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING)', p_error_desc);
581: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING):'||p_error_desc);

Line 578: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

574: EXCEPTION
575: WHEN OTHERS THEN
576: p_error_code := c_FAILURE;
577: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
578: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
579: p_error_desc := fnd_message.get;
580: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING)', p_error_desc);
581: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING):'||p_error_desc);
582: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

Line 579: p_error_desc := fnd_message.get;

575: WHEN OTHERS THEN
576: p_error_code := c_FAILURE;
577: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
578: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
579: p_error_desc := fnd_message.get;
580: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING)', p_error_desc);
581: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING):'||p_error_desc);
582: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
583: fnd_message.set_token('MESSAGE' , 'Error in Getting Balancing Segment.'||CRLF||

Line 582: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

578: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
579: p_error_desc := fnd_message.get;
580: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING)', p_error_desc);
581: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING):'||p_error_desc);
582: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
583: fnd_message.set_token('MESSAGE' , 'Error in Getting Balancing Segment.'||CRLF||
584: 'Balancing Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
585: p_error_desc := fnd_message.get;
586: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING)', p_error_desc);

Line 583: fnd_message.set_token('MESSAGE' , 'Error in Getting Balancing Segment.'||CRLF||

579: p_error_desc := fnd_message.get;
580: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING)', p_error_desc);
581: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING):'||p_error_desc);
582: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
583: fnd_message.set_token('MESSAGE' , 'Error in Getting Balancing Segment.'||CRLF||
584: 'Balancing Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
585: p_error_desc := fnd_message.get;
586: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING)', p_error_desc);
587: l_ledger_rec.balancing_seg_num := NULL;

Line 585: p_error_desc := fnd_message.get;

581: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING):'||p_error_desc);
582: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
583: fnd_message.set_token('MESSAGE' , 'Error in Getting Balancing Segment.'||CRLF||
584: 'Balancing Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
585: p_error_desc := fnd_message.get;
586: stack_error (l_procedure_name, 'SELECT_FND_ID_FLEX_SEGMENTS (GL_BALANCING)', p_error_desc);
587: l_ledger_rec.balancing_seg_num := NULL;
588: l_ledger_rec.balancing_seg_name := NULL;
589: END;

Line 611: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

607: trace(C_STATE_LEVEL, l_procedure_name, 'fyr_segment_id='||l_ledger_rec.fyr_segment_id);
608: EXCEPTION
609: WHEN NO_DATA_FOUND THEN
610: p_error_code := c_FAILURE;
611: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
612: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
613: p_error_desc := fnd_message.get;
614: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_SEGMENT', p_error_desc);
615: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_SEGMENT:'||p_error_desc);

Line 612: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

608: EXCEPTION
609: WHEN NO_DATA_FOUND THEN
610: p_error_code := c_FAILURE;
611: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
612: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
613: p_error_desc := fnd_message.get;
614: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_SEGMENT', p_error_desc);
615: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_SEGMENT:'||p_error_desc);
616: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

Line 613: p_error_desc := fnd_message.get;

609: WHEN NO_DATA_FOUND THEN
610: p_error_code := c_FAILURE;
611: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
612: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
613: p_error_desc := fnd_message.get;
614: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_SEGMENT', p_error_desc);
615: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_SEGMENT:'||p_error_desc);
616: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
617: fnd_message.set_token('MESSAGE' , 'Error in setup of Define Federal Options Form.'||CRLF||

Line 616: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

612: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
613: p_error_desc := fnd_message.get;
614: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_SEGMENT', p_error_desc);
615: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_SEGMENT:'||p_error_desc);
616: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
617: fnd_message.set_token('MESSAGE' , 'Error in setup of Define Federal Options Form.'||CRLF||
618: 'BFY Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
619: p_error_desc := fnd_message.get;
620: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_SEGMENT', p_error_desc);

Line 617: fnd_message.set_token('MESSAGE' , 'Error in setup of Define Federal Options Form.'||CRLF||

613: p_error_desc := fnd_message.get;
614: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_SEGMENT', p_error_desc);
615: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_SEGMENT:'||p_error_desc);
616: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
617: fnd_message.set_token('MESSAGE' , 'Error in setup of Define Federal Options Form.'||CRLF||
618: 'BFY Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
619: p_error_desc := fnd_message.get;
620: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_SEGMENT', p_error_desc);
621: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_SEGMENT:'||p_error_desc);

Line 619: p_error_desc := fnd_message.get;

615: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_SEGMENT:'||p_error_desc);
616: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
617: fnd_message.set_token('MESSAGE' , 'Error in setup of Define Federal Options Form.'||CRLF||
618: 'BFY Segment is not Defined for the Ledger '||l_ledger_rec.ledger_name);
619: p_error_desc := fnd_message.get;
620: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_SEGMENT', p_error_desc);
621: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_SEGMENT:'||p_error_desc);
622: l_ledger_rec.bfy_segment_num := NULL;
623: l_ledger_rec.fyr_segment_id := NULL;

Line 640: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

636: trace(C_STATE_LEVEL, l_procedure_name, 'END');
637: EXCEPTION
638: WHEN OTHERS THEN
639: p_error_code := c_FAILURE;
640: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
641: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
642: p_error_desc := fnd_message.get;
643: stack_error (l_procedure_name, 'FINAL', p_error_desc);
644: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 641: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

637: EXCEPTION
638: WHEN OTHERS THEN
639: p_error_code := c_FAILURE;
640: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
641: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
642: p_error_desc := fnd_message.get;
643: stack_error (l_procedure_name, 'FINAL', p_error_desc);
644: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
645: END;

Line 642: p_error_desc := fnd_message.get;

638: WHEN OTHERS THEN
639: p_error_code := c_FAILURE;
640: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
641: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
642: p_error_desc := fnd_message.get;
643: stack_error (l_procedure_name, 'FINAL', p_error_desc);
644: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
645: END;
646:

Line 679: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

675: AND a.fund_value = p_fund_value;
676: EXCEPTION
677: WHEN NO_DATA_FOUND THEN
678: p_error_code := c_FAILURE;
679: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
680: fnd_message.set_token('MESSAGE' , 'Details for Fund '||p_fund_value||' could not be found in Treasury/Fund Setup');
681: p_error_desc := fnd_message.get;
682: stack_error (l_procedure_name, 'FINAL', p_error_desc);
683: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 680: fnd_message.set_token('MESSAGE' , 'Details for Fund '||p_fund_value||' could not be found in Treasury/Fund Setup');

676: EXCEPTION
677: WHEN NO_DATA_FOUND THEN
678: p_error_code := c_FAILURE;
679: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
680: fnd_message.set_token('MESSAGE' , 'Details for Fund '||p_fund_value||' could not be found in Treasury/Fund Setup');
681: p_error_desc := fnd_message.get;
682: stack_error (l_procedure_name, 'FINAL', p_error_desc);
683: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
684: END;

Line 681: p_error_desc := fnd_message.get;

677: WHEN NO_DATA_FOUND THEN
678: p_error_code := c_FAILURE;
679: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
680: fnd_message.set_token('MESSAGE' , 'Details for Fund '||p_fund_value||' could not be found in Treasury/Fund Setup');
681: p_error_desc := fnd_message.get;
682: stack_error (l_procedure_name, 'FINAL', p_error_desc);
683: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
684: END;
685:

Line 698: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

694: trace(C_PROC_LEVEL, l_procedure_name, 'END');
695: EXCEPTION
696: WHEN OTHERS THEN
697: p_error_code := c_FAILURE;
698: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
699: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
700: p_error_desc := fnd_message.get;
701: stack_error (l_procedure_name, 'FINAL', p_error_desc);
702: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 699: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

695: EXCEPTION
696: WHEN OTHERS THEN
697: p_error_code := c_FAILURE;
698: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
699: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
700: p_error_desc := fnd_message.get;
701: stack_error (l_procedure_name, 'FINAL', p_error_desc);
702: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
703: END;

Line 700: p_error_desc := fnd_message.get;

696: WHEN OTHERS THEN
697: p_error_code := c_FAILURE;
698: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
699: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
700: p_error_desc := fnd_message.get;
701: stack_error (l_procedure_name, 'FINAL', p_error_desc);
702: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
703: END;
704:

Line 799: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

795: trace(C_PROC_LEVEL, l_procedure_name, 'END');
796: EXCEPTION
797: WHEN OTHERS THEN
798: p_error_code := c_FAILURE;
799: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
800: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
801: p_error_desc := fnd_message.get;
802: stack_error (l_procedure_name, 'FINAL', p_error_desc);
803: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 800: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

796: EXCEPTION
797: WHEN OTHERS THEN
798: p_error_code := c_FAILURE;
799: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
800: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
801: p_error_desc := fnd_message.get;
802: stack_error (l_procedure_name, 'FINAL', p_error_desc);
803: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
804: END;

Line 801: p_error_desc := fnd_message.get;

797: WHEN OTHERS THEN
798: p_error_code := c_FAILURE;
799: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
800: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
801: p_error_desc := fnd_message.get;
802: stack_error (l_procedure_name, 'FINAL', p_error_desc);
803: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
804: END;
805:

Line 893: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

889: trace(C_PROC_LEVEL, l_procedure_name, 'END');
890: EXCEPTION
891: WHEN OTHERS THEN
892: p_error_code := c_FAILURE;
893: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
894: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
895: p_error_desc := fnd_message.get;
896: stack_error (l_procedure_name, 'FINAL', p_error_desc);
897: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 894: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

890: EXCEPTION
891: WHEN OTHERS THEN
892: p_error_code := c_FAILURE;
893: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
894: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
895: p_error_desc := fnd_message.get;
896: stack_error (l_procedure_name, 'FINAL', p_error_desc);
897: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
898: END;

Line 895: p_error_desc := fnd_message.get;

891: WHEN OTHERS THEN
892: p_error_code := c_FAILURE;
893: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
894: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
895: p_error_desc := fnd_message.get;
896: stack_error (l_procedure_name, 'FINAL', p_error_desc);
897: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
898: END;
899:

Line 958: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

954: trace(C_PROC_LEVEL, l_procedure_name, 'END');
955: EXCEPTION
956: WHEN OTHERS THEN
957: p_error_code := c_FAILURE;
958: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
959: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
960: p_error_desc := fnd_message.get;
961: stack_error (l_procedure_name, 'FINAL', p_error_desc);
962: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 959: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

955: EXCEPTION
956: WHEN OTHERS THEN
957: p_error_code := c_FAILURE;
958: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
959: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
960: p_error_desc := fnd_message.get;
961: stack_error (l_procedure_name, 'FINAL', p_error_desc);
962: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
963: END get_fund_details;

Line 960: p_error_desc := fnd_message.get;

956: WHEN OTHERS THEN
957: p_error_code := c_FAILURE;
958: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
959: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
960: p_error_desc := fnd_message.get;
961: stack_error (l_procedure_name, 'FINAL', p_error_desc);
962: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
963: END get_fund_details;
964:

Line 1016: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1012: trace(C_STATE_LEVEL, l_procedure_name, 'l_bfy_map_year='||l_bfy_map_year);
1013: EXCEPTION
1014: WHEN NO_DATA_FOUND THEN
1015: p_error_code := c_FAILURE;
1016: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1017: fnd_message.set_token('MESSAGE' , 'Error in setup of Define Federal Options Form.'||CRLF||
1018: 'Segment Mapping is missing for the Ledger '||l_ledger_info.ledger_name||'. '||CRLF||
1019: 'Mapping of BFY Year '||p_bfy_value||' is missing.');
1020: p_error_desc := fnd_message.get;

Line 1017: fnd_message.set_token('MESSAGE' , 'Error in setup of Define Federal Options Form.'||CRLF||

1013: EXCEPTION
1014: WHEN NO_DATA_FOUND THEN
1015: p_error_code := c_FAILURE;
1016: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1017: fnd_message.set_token('MESSAGE' , 'Error in setup of Define Federal Options Form.'||CRLF||
1018: 'Segment Mapping is missing for the Ledger '||l_ledger_info.ledger_name||'. '||CRLF||
1019: 'Mapping of BFY Year '||p_bfy_value||' is missing.');
1020: p_error_desc := fnd_message.get;
1021: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_MAP', p_error_desc);

Line 1020: p_error_desc := fnd_message.get;

1016: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1017: fnd_message.set_token('MESSAGE' , 'Error in setup of Define Federal Options Form.'||CRLF||
1018: 'Segment Mapping is missing for the Ledger '||l_ledger_info.ledger_name||'. '||CRLF||
1019: 'Mapping of BFY Year '||p_bfy_value||' is missing.');
1020: p_error_desc := fnd_message.get;
1021: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_MAP', p_error_desc);
1022: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_MAP:'||p_error_desc);
1023: WHEN OTHERS THEN
1024: p_error_code := c_FAILURE;

Line 1025: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1021: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_MAP', p_error_desc);
1022: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_MAP:'||p_error_desc);
1023: WHEN OTHERS THEN
1024: p_error_code := c_FAILURE;
1025: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1026: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1027: p_error_desc := fnd_message.get;
1028: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_MAP', p_error_desc);
1029: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_MAP:'||p_error_desc);

Line 1026: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1022: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_MAP:'||p_error_desc);
1023: WHEN OTHERS THEN
1024: p_error_code := c_FAILURE;
1025: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1026: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1027: p_error_desc := fnd_message.get;
1028: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_MAP', p_error_desc);
1029: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_MAP:'||p_error_desc);
1030: END;

Line 1027: p_error_desc := fnd_message.get;

1023: WHEN OTHERS THEN
1024: p_error_code := c_FAILURE;
1025: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1026: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1027: p_error_desc := fnd_message.get;
1028: stack_error (l_procedure_name, 'SELECT_FV_PYA_FISCALYEAR_MAP', p_error_desc);
1029: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_FV_PYA_FISCALYEAR_MAP:'||p_error_desc);
1030: END;
1031: END IF;

Line 1046: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1042: trace(C_STATE_LEVEL, l_procedure_name, 'l_transaction_year='||l_transaction_year);
1043: EXCEPTION
1044: WHEN OTHERS THEN
1045: p_error_code := c_FAILURE;
1046: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1047: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1048: p_error_desc := fnd_message.get;
1049: stack_error (l_procedure_name, 'SELECT_GL_PERIOD_STATUSES', p_error_desc);
1050: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_GL_PERIOD_STATUSES:'||p_error_desc);

Line 1047: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1043: EXCEPTION
1044: WHEN OTHERS THEN
1045: p_error_code := c_FAILURE;
1046: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1047: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1048: p_error_desc := fnd_message.get;
1049: stack_error (l_procedure_name, 'SELECT_GL_PERIOD_STATUSES', p_error_desc);
1050: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_GL_PERIOD_STATUSES:'||p_error_desc);
1051: END;

Line 1048: p_error_desc := fnd_message.get;

1044: WHEN OTHERS THEN
1045: p_error_code := c_FAILURE;
1046: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1047: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1048: p_error_desc := fnd_message.get;
1049: stack_error (l_procedure_name, 'SELECT_GL_PERIOD_STATUSES', p_error_desc);
1050: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_GL_PERIOD_STATUSES:'||p_error_desc);
1051: END;
1052: END IF;

Line 1074: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1070: trace(C_PROC_LEVEL, l_procedure_name, 'END');
1071: EXCEPTION
1072: WHEN OTHERS THEN
1073: p_error_code := c_FAILURE;
1074: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1075: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1076: p_error_desc := fnd_message.get;
1077: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1078: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 1075: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1071: EXCEPTION
1072: WHEN OTHERS THEN
1073: p_error_code := c_FAILURE;
1074: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1075: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1076: p_error_desc := fnd_message.get;
1077: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1078: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1079: END get_prior_year_status;

Line 1076: p_error_desc := fnd_message.get;

1072: WHEN OTHERS THEN
1073: p_error_code := c_FAILURE;
1074: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1075: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1076: p_error_desc := fnd_message.get;
1077: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1078: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1079: END get_prior_year_status;
1080:

Line 1111: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1107:
1108: EXCEPTION
1109: WHEN OTHERS THEN
1110: p_error_code := c_FAILURE;
1111: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1112: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1113: p_error_desc := fnd_message.get;
1114: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1115: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 1112: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1108: EXCEPTION
1109: WHEN OTHERS THEN
1110: p_error_code := c_FAILURE;
1111: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1112: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1113: p_error_desc := fnd_message.get;
1114: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1115: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1116: END dump_gt_table;

Line 1113: p_error_desc := fnd_message.get;

1109: WHEN OTHERS THEN
1110: p_error_code := c_FAILURE;
1111: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1112: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1113: p_error_desc := fnd_message.get;
1114: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1115: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1116: END dump_gt_table;
1117:

Line 1288: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1284: END IF;
1285: EXCEPTION
1286: WHEN OTHERS THEN
1287: p_error_code := c_FAILURE;
1288: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1289: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1290: p_error_desc := fnd_message.get;
1291: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1292: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 1289: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1285: EXCEPTION
1286: WHEN OTHERS THEN
1287: p_error_code := c_FAILURE;
1288: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1289: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1290: p_error_desc := fnd_message.get;
1291: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1292: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1293: END;

Line 1290: p_error_desc := fnd_message.get;

1286: WHEN OTHERS THEN
1287: p_error_code := c_FAILURE;
1288: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1289: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1290: p_error_desc := fnd_message.get;
1291: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1292: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1293: END;
1294:

Line 1357: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1353: -------------------------------------------------------------------------
1354: EXCEPTION
1355: WHEN OTHERS THEN
1356: p_error_code := c_FAILURE;
1357: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1358: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1359: p_error_desc := fnd_message.get;
1360: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1361: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 1358: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1354: EXCEPTION
1355: WHEN OTHERS THEN
1356: p_error_code := c_FAILURE;
1357: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1358: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1359: p_error_desc := fnd_message.get;
1360: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1361: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1362: END;

Line 1359: p_error_desc := fnd_message.get;

1355: WHEN OTHERS THEN
1356: p_error_code := c_FAILURE;
1357: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1358: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1359: p_error_desc := fnd_message.get;
1360: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1361: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1362: END;
1363:

Line 1423: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1419: WHEN NO_DATA_FOUND THEN
1420: l_template_id := NULL;
1421: WHEN OTHERS THEN
1422: p_error_code := c_FAILURE;
1423: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1424: p_error_desc := fnd_message.get;
1425: stack_error (l_procedure_name, 'SELECT_fv_pya_fiscalyear_segment', p_error_desc);
1426: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_pya_fiscalyear_segment:'||p_error_desc);
1427: END;

Line 1424: p_error_desc := fnd_message.get;

1420: l_template_id := NULL;
1421: WHEN OTHERS THEN
1422: p_error_code := c_FAILURE;
1423: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1424: p_error_desc := fnd_message.get;
1425: stack_error (l_procedure_name, 'SELECT_fv_pya_fiscalyear_segment', p_error_desc);
1426: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_pya_fiscalyear_segment:'||p_error_desc);
1427: END;
1428: END IF;

Line 1450: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1446: trace(C_STATE_LEVEL, l_procedure_name, 'l_period_name='||l_period_name);
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: p_error_code := c_FAILURE;
1450: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1451: p_error_desc := fnd_message.get;
1452: stack_error (l_procedure_name, 'SELECT_gl_period_statuses', p_error_desc);
1453: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_gl_period_statuses:'||p_error_desc);
1454: END;

Line 1451: p_error_desc := fnd_message.get;

1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: p_error_code := c_FAILURE;
1450: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1451: p_error_desc := fnd_message.get;
1452: stack_error (l_procedure_name, 'SELECT_gl_period_statuses', p_error_desc);
1453: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_gl_period_statuses:'||p_error_desc);
1454: END;
1455: END IF;

Line 1557: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1553:
1554: EXCEPTION
1555: WHEN OTHERS THEN
1556: p_error_code := c_FAILURE;
1557: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1558: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1559: p_error_desc := fnd_message.get;
1560: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1561: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 1558: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1554: EXCEPTION
1555: WHEN OTHERS THEN
1556: p_error_code := c_FAILURE;
1557: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1558: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1559: p_error_desc := fnd_message.get;
1560: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1561: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1562: END get_anticipated_ts_amt;

Line 1559: p_error_desc := fnd_message.get;

1555: WHEN OTHERS THEN
1556: p_error_code := c_FAILURE;
1557: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1558: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1559: p_error_desc := fnd_message.get;
1560: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1561: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1562: END get_anticipated_ts_amt;
1563:

Line 1634: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1630: trace(C_PROC_LEVEL, l_procedure_name, 'END');
1631: EXCEPTION
1632: WHEN OTHERS THEN
1633: p_error_code := c_FAILURE;
1634: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1635: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1636: p_error_desc := fnd_message.get;
1637: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1638: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 1635: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1631: EXCEPTION
1632: WHEN OTHERS THEN
1633: p_error_code := c_FAILURE;
1634: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1635: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1636: p_error_desc := fnd_message.get;
1637: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1638: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1639: END;

Line 1636: p_error_desc := fnd_message.get;

1632: WHEN OTHERS THEN
1633: p_error_code := c_FAILURE;
1634: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1635: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1636: p_error_desc := fnd_message.get;
1637: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1638: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1639: END;
1640:

Line 1685: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1681: trace(C_PROC_LEVEL, l_procedure_name, 'END');
1682: EXCEPTION
1683: WHEN OTHERS THEN
1684: p_error_code := c_FAILURE;
1685: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1686: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1687: p_error_desc := fnd_message.get;
1688: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1689: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 1686: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1682: EXCEPTION
1683: WHEN OTHERS THEN
1684: p_error_code := c_FAILURE;
1685: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1686: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1687: p_error_desc := fnd_message.get;
1688: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1689: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1690: END;

Line 1687: p_error_desc := fnd_message.get;

1683: WHEN OTHERS THEN
1684: p_error_code := c_FAILURE;
1685: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1686: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1687: p_error_desc := fnd_message.get;
1688: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1689: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1690: END;
1691:

Line 1794: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1790: trace(C_STATE_LEVEL, l_procedure_name, 'l_tot_acc_commitment_amt:'||l_tot_acc_unreserve_bud_amount);
1791: EXCEPTION
1792: WHEN OTHERS THEN
1793: p_error_code := c_FAILURE;
1794: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1795: p_error_desc := fnd_message.get;
1796: stack_error (l_procedure_name, 'SELECT_fv_extract_detail_gt', p_error_desc);
1797: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_extract_detail_gt:'||p_error_desc);
1798: END;

Line 1795: p_error_desc := fnd_message.get;

1791: EXCEPTION
1792: WHEN OTHERS THEN
1793: p_error_code := c_FAILURE;
1794: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1795: p_error_desc := fnd_message.get;
1796: stack_error (l_procedure_name, 'SELECT_fv_extract_detail_gt', p_error_desc);
1797: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_extract_detail_gt:'||p_error_desc);
1798: END;
1799: END IF;

Line 1838: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1834: trace(C_STATE_LEVEL, l_procedure_name, 'Updated'||SQL%ROWCOUNT||' rows.');
1835: EXCEPTION
1836: WHEN OTHERS THEN
1837: p_error_code := c_FAILURE;
1838: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1839: p_error_desc := fnd_message.get;
1840: stack_error (l_procedure_name, 'UPDATE_fv_extract_detail_gt', p_error_desc);
1841: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:UPDATE_fv_extract_detail_gt:'||p_error_desc);
1842: END;

Line 1839: p_error_desc := fnd_message.get;

1835: EXCEPTION
1836: WHEN OTHERS THEN
1837: p_error_code := c_FAILURE;
1838: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1839: p_error_desc := fnd_message.get;
1840: stack_error (l_procedure_name, 'UPDATE_fv_extract_detail_gt', p_error_desc);
1841: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:UPDATE_fv_extract_detail_gt:'||p_error_desc);
1842: END;
1843: END IF;

Line 1950: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1946: AND f.treasury_symbol_id = ts_rec.treasury_symbol_id;
1947: EXCEPTION
1948: WHEN OTHERS THEN
1949: p_error_code := c_FAILURE;
1950: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1951: p_error_desc := fnd_message.get;
1952: stack_error (l_procedure_name, 'UPDATE_fv_extract_detail_gt', p_error_desc);
1953: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:UPDATE_fv_extract_detail_gt:'||p_error_desc);
1954: END;

Line 1951: p_error_desc := fnd_message.get;

1947: EXCEPTION
1948: WHEN OTHERS THEN
1949: p_error_code := c_FAILURE;
1950: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1951: p_error_desc := fnd_message.get;
1952: stack_error (l_procedure_name, 'UPDATE_fv_extract_detail_gt', p_error_desc);
1953: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:UPDATE_fv_extract_detail_gt:'||p_error_desc);
1954: END;
1955:

Line 1975: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1971: trace(C_PROC_LEVEL, l_procedure_name, 'END');
1972: EXCEPTION
1973: WHEN OTHERS THEN
1974: p_error_code := c_FAILURE;
1975: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1976: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1977: p_error_desc := fnd_message.get;
1978: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1979: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 1976: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

1972: EXCEPTION
1973: WHEN OTHERS THEN
1974: p_error_code := c_FAILURE;
1975: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1976: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1977: p_error_desc := fnd_message.get;
1978: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1979: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1980: END;

Line 1977: p_error_desc := fnd_message.get;

1973: WHEN OTHERS THEN
1974: p_error_code := c_FAILURE;
1975: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1976: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1977: p_error_desc := fnd_message.get;
1978: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1979: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1980: END;
1981:

Line 2012: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

2008: WHERE t.treasury_symbol_id = g.treasury_symbol_id
2009: AND NVL(t.no_pya_acct_flag, 'N') = 'Y')) LOOP
2010: g_CurrentEventId := exp_funds_rec.event_id;
2011: p_error_code := c_FAILURE;
2012: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2013: fnd_message.set_token('MESSAGE' , 'Expired Fund '||exp_funds_rec.fund_value||' is used in current year.');
2014: p_error_desc := fnd_message.get;
2015: stack_error (l_procedure_name, 'FINAL', p_error_desc);
2016: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:exp_funds_rec:'||p_error_desc);

Line 2013: fnd_message.set_token('MESSAGE' , 'Expired Fund '||exp_funds_rec.fund_value||' is used in current year.');

2009: AND NVL(t.no_pya_acct_flag, 'N') = 'Y')) LOOP
2010: g_CurrentEventId := exp_funds_rec.event_id;
2011: p_error_code := c_FAILURE;
2012: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2013: fnd_message.set_token('MESSAGE' , 'Expired Fund '||exp_funds_rec.fund_value||' is used in current year.');
2014: p_error_desc := fnd_message.get;
2015: stack_error (l_procedure_name, 'FINAL', p_error_desc);
2016: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:exp_funds_rec:'||p_error_desc);
2017: END LOOP;

Line 2014: p_error_desc := fnd_message.get;

2010: g_CurrentEventId := exp_funds_rec.event_id;
2011: p_error_code := c_FAILURE;
2012: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2013: fnd_message.set_token('MESSAGE' , 'Expired Fund '||exp_funds_rec.fund_value||' is used in current year.');
2014: p_error_desc := fnd_message.get;
2015: stack_error (l_procedure_name, 'FINAL', p_error_desc);
2016: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:exp_funds_rec:'||p_error_desc);
2017: END LOOP;
2018:

Line 2024: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

2020: trace(C_PROC_LEVEL, l_procedure_name, 'END');
2021: EXCEPTION
2022: WHEN OTHERS THEN
2023: p_error_code := c_FAILURE;
2024: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2025: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
2026: p_error_desc := fnd_message.get;
2027: stack_error (l_procedure_name, 'FINAL', p_error_desc);
2028: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 2025: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

2021: EXCEPTION
2022: WHEN OTHERS THEN
2023: p_error_code := c_FAILURE;
2024: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2025: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
2026: p_error_desc := fnd_message.get;
2027: stack_error (l_procedure_name, 'FINAL', p_error_desc);
2028: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
2029: END;

Line 2026: p_error_desc := fnd_message.get;

2022: WHEN OTHERS THEN
2023: p_error_code := c_FAILURE;
2024: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2025: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
2026: p_error_desc := fnd_message.get;
2027: stack_error (l_procedure_name, 'FINAL', p_error_desc);
2028: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
2029: END;
2030:

Line 2081: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

2077: trace(C_PROC_LEVEL, l_procedure_name, 'END');
2078: EXCEPTION
2079: WHEN OTHERS THEN
2080: p_error_code := c_FAILURE;
2081: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2082: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
2083: p_error_desc := fnd_message.get;
2084: stack_error (l_procedure_name, 'FINAL', p_error_desc);
2085: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);

Line 2082: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);

2078: EXCEPTION
2079: WHEN OTHERS THEN
2080: p_error_code := c_FAILURE;
2081: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2082: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
2083: p_error_desc := fnd_message.get;
2084: stack_error (l_procedure_name, 'FINAL', p_error_desc);
2085: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
2086: END;

Line 2083: p_error_desc := fnd_message.get;

2079: WHEN OTHERS THEN
2080: p_error_code := c_FAILURE;
2081: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2082: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
2083: p_error_desc := fnd_message.get;
2084: stack_error (l_procedure_name, 'FINAL', p_error_desc);
2085: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
2086: END;
2087: