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.PSB_WORKFLOW_PVT dependencies on FND_API

Line 167: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

163: p_return_status => l_return_status,
164: p_budget_calendar_id => l_budget_calendar_id
165: );
166: --
167: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
168: FND_MSG_PUB.Add_Exc_Msg( 'PSB_WS_Acct1', 'Cache_Budget_Calendar') ;
169: RAISE FND_API.G_EXC_ERROR ;
170: END IF ;
171: --

Line 169: RAISE FND_API.G_EXC_ERROR ;

165: );
166: --
167: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
168: FND_MSG_PUB.Add_Exc_Msg( 'PSB_WS_Acct1', 'Cache_Budget_Calendar') ;
169: RAISE FND_API.G_EXC_ERROR ;
170: END IF ;
171: --
172: END IF ;
173:

Line 207: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

203: Add_Debug_Info('1- WS for BG '||
204: to_char(l_budget_groups_rec.budget_group_id) ||
205: ' Status '||l_return_status) ;
206:
207: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
208: RAISE FND_API.G_EXC_ERROR ;
209: END IF ;
210: --
211:

Line 208: RAISE FND_API.G_EXC_ERROR ;

204: to_char(l_budget_groups_rec.budget_group_id) ||
205: ' Status '||l_return_status) ;
206:
207: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
208: RAISE FND_API.G_EXC_ERROR ;
209: END IF ;
210: --
211:
212: -- download flag

Line 224: p_init_msg_list => FND_API.G_FALSE ,

220:
221: PSB_EXCEL_PVT.Move_To_Interface
222: (
223: p_api_version => l_api_version ,
224: p_init_msg_list => FND_API.G_FALSE ,
225: p_commit => FND_API.G_FALSE ,
226: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
227: p_return_status => l_return_status ,
228: p_msg_count => l_msg_count ,

Line 225: p_commit => FND_API.G_FALSE ,

221: PSB_EXCEL_PVT.Move_To_Interface
222: (
223: p_api_version => l_api_version ,
224: p_init_msg_list => FND_API.G_FALSE ,
225: p_commit => FND_API.G_FALSE ,
226: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
227: p_return_status => l_return_status ,
228: p_msg_count => l_msg_count ,
229: p_msg_data => l_msg_data ,

Line 226: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

222: (
223: p_api_version => l_api_version ,
224: p_init_msg_list => FND_API.G_FALSE ,
225: p_commit => FND_API.G_FALSE ,
226: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
227: p_return_status => l_return_status ,
228: p_msg_count => l_msg_count ,
229: p_msg_data => l_msg_data ,
230: --

Line 235: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

231: p_export_name => l_export_name,
232: p_worksheet_id => l_created_worksheet_id
233: );
234:
235: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
236: RAISE FND_API.G_EXC_ERROR ;
237: END IF ;
238: --
239:

Line 236: RAISE FND_API.G_EXC_ERROR ;

232: p_worksheet_id => l_created_worksheet_id
233: );
234:
235: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
236: RAISE FND_API.G_EXC_ERROR ;
237: END IF ;
238: --
239:
240: Add_Debug_Info('After download ' || ' Status ' || l_return_status) ;

Line 276: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

272: p_return_status => l_return_status
273: );
274: --
275:
276: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
277: RAISE FND_API.G_EXC_ERROR ;
278: END IF ;
279: --
280:

Line 277: RAISE FND_API.G_EXC_ERROR ;

273: );
274: --
275:
276: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
277: RAISE FND_API.G_EXC_ERROR ;
278: END IF ;
279: --
280:
281: IF l_budget_groups_rec.download_flag = 'Y' AND

Line 297: p_init_msg_list => FND_API.G_FALSE ,

293:
294: PSB_EXCEL_PVT. Move_To_Interface
295: (
296: p_api_version => l_api_version ,
297: p_init_msg_list => FND_API.G_FALSE ,
298: p_commit => FND_API.G_FALSE ,
299: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
300: p_return_status => l_return_status ,
301: p_msg_count => l_msg_count ,

Line 298: p_commit => FND_API.G_FALSE ,

294: PSB_EXCEL_PVT. Move_To_Interface
295: (
296: p_api_version => l_api_version ,
297: p_init_msg_list => FND_API.G_FALSE ,
298: p_commit => FND_API.G_FALSE ,
299: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
300: p_return_status => l_return_status ,
301: p_msg_count => l_msg_count ,
302: p_msg_data => l_msg_data ,

Line 299: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

295: (
296: p_api_version => l_api_version ,
297: p_init_msg_list => FND_API.G_FALSE ,
298: p_commit => FND_API.G_FALSE ,
299: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
300: p_return_status => l_return_status ,
301: p_msg_count => l_msg_count ,
302: p_msg_data => l_msg_data ,
303: --

Line 308: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

304: p_export_name => l_export_name,
305: p_worksheet_id => l_created_worksheet_id
306: );
307:
308: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
309: RAISE FND_API.G_EXC_ERROR ;
310: END IF ;
311:
312: Add_Debug_Info('After download ' || ' Status '||l_return_status) ;

Line 309: RAISE FND_API.G_EXC_ERROR ;

305: p_worksheet_id => l_created_worksheet_id
306: );
307:
308: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
309: RAISE FND_API.G_EXC_ERROR ;
310: END IF ;
311:
312: Add_Debug_Info('After download ' || ' Status '||l_return_status) ;
313:

Line 329: WHEN FND_API.G_EXC_ERROR THEN

325: COMMIT WORK;
326: --
327: EXCEPTION
328: --
329: WHEN FND_API.G_EXC_ERROR THEN
330: --
331: /*For Bug No : 2236283 Start*/
332: --ROLLBACK to statements are commented and blind ROLLBACKs are implemented
333: --since COMMIT is performed in child procedure and

Line 339: p_print_header => FND_API.G_TRUE ) ;

335:
336: --ROLLBACK TO Distribute_WS_Pvt ;
337: ROLLBACK;
338: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
339: p_print_header => FND_API.G_TRUE ) ;
340: retcode := 2 ;
341: --
342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
343: --

Line 342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

338: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
339: p_print_header => FND_API.G_TRUE ) ;
340: retcode := 2 ;
341: --
342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
343: --
344: --ROLLBACK TO Distribute_WS_Pvt ;
345: ROLLBACK;
346: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

Line 347: p_print_header => FND_API.G_TRUE ) ;

343: --
344: --ROLLBACK TO Distribute_WS_Pvt ;
345: ROLLBACK;
346: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
347: p_print_header => FND_API.G_TRUE ) ;
348: retcode := 2 ;
349: --
350: WHEN OTHERS THEN
351: --

Line 362: p_print_header => FND_API.G_TRUE ) ;

358: l_api_name ) ;
359: END IF ;
360: --
361: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
362: p_print_header => FND_API.G_TRUE ) ;
363: retcode := 2 ;
364: --
365: END Distribute_WS ;
366: /*---------------------------------------------------------------------------*/

Line 428: p_init_msg_list => FND_API.G_TRUE,

424: IF p_review_group_flag <> 'Y' THEN
425: PSB_Submit_Worksheet_PVT.Check_Review_Groups
426: (
427: p_api_version => 1.0 ,
428: p_init_msg_list => FND_API.G_TRUE,
429: p_commit => FND_API.G_FALSE,
430: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
431: p_return_status => l_return_status,
432: p_msg_count => l_msg_count,

Line 429: p_commit => FND_API.G_FALSE,

425: PSB_Submit_Worksheet_PVT.Check_Review_Groups
426: (
427: p_api_version => 1.0 ,
428: p_init_msg_list => FND_API.G_TRUE,
429: p_commit => FND_API.G_FALSE,
430: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
431: p_return_status => l_return_status,
432: p_msg_count => l_msg_count,
433: p_msg_data => l_msg_data,

Line 430: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

426: (
427: p_api_version => 1.0 ,
428: p_init_msg_list => FND_API.G_TRUE,
429: p_commit => FND_API.G_FALSE,
430: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
431: p_return_status => l_return_status,
432: p_msg_count => l_msg_count,
433: p_msg_data => l_msg_data,
434: --

Line 439: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

435: p_worksheet_id => p_worksheet_id,
436: p_review_group_exists => l_review_group_exists
437: );
438: --
439: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
440: RAISE FND_API.G_EXC_ERROR ;
441: END IF ;
442: --
443: IF l_review_group_exists = 'T' THEN

Line 440: RAISE FND_API.G_EXC_ERROR ;

436: p_review_group_exists => l_review_group_exists
437: );
438: --
439: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
440: RAISE FND_API.G_EXC_ERROR ;
441: END IF ;
442: --
443: IF l_review_group_exists = 'T' THEN
444: l_review_group_exists := 'Y';

Line 461: p_init_msg_list => FND_API.G_FALSE ,

457:
458: PSB_WS_Ops_Pvt.Check_WS_Ops_Concurrency
459: (
460: p_api_version => 1.0 ,
461: p_init_msg_list => FND_API.G_FALSE ,
462: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
463: p_return_status => l_return_status ,
464: p_msg_count => l_msg_count ,
465: p_msg_data => l_msg_data ,

Line 462: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,

458: PSB_WS_Ops_Pvt.Check_WS_Ops_Concurrency
459: (
460: p_api_version => 1.0 ,
461: p_init_msg_list => FND_API.G_FALSE ,
462: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
463: p_return_status => l_return_status ,
464: p_msg_count => l_msg_count ,
465: p_msg_data => l_msg_data ,
466: --

Line 471: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

467: p_worksheet_id => p_worksheet_id ,
468: p_operation_type => p_operation_type
469: );
470: --
471: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
472: FND_MSG_PUB.Add_Exc_Msg( 'PSB_WS_Ops_Pvt', 'Check_WS_Ops_Concurrency') ;
473: RAISE FND_API.G_EXC_ERROR ;
474: END IF ;
475: --

Line 473: RAISE FND_API.G_EXC_ERROR ;

469: );
470: --
471: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
472: FND_MSG_PUB.Add_Exc_Msg( 'PSB_WS_Ops_Pvt', 'Check_WS_Ops_Concurrency') ;
473: RAISE FND_API.G_EXC_ERROR ;
474: END IF ;
475: --
476:
477: --

Line 522: p_init_msg_list => FND_API.G_FALSE,

518: -- Start the Workflow 'Submit Process'.
519: --
520: PSB_Submit_Worksheet_PVT.Start_Process
521: ( p_api_version => 1.0 ,
522: p_init_msg_list => FND_API.G_FALSE,
523: p_commit => FND_API.G_FALSE,
524: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
525: p_return_status => l_return_status ,
526: p_msg_count => l_msg_count ,

Line 523: p_commit => FND_API.G_FALSE,

519: --
520: PSB_Submit_Worksheet_PVT.Start_Process
521: ( p_api_version => 1.0 ,
522: p_init_msg_list => FND_API.G_FALSE,
523: p_commit => FND_API.G_FALSE,
524: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
525: p_return_status => l_return_status ,
526: p_msg_count => l_msg_count ,
527: p_msg_data => l_msg_data ,

Line 524: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

520: PSB_Submit_Worksheet_PVT.Start_Process
521: ( p_api_version => 1.0 ,
522: p_init_msg_list => FND_API.G_FALSE,
523: p_commit => FND_API.G_FALSE,
524: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
525: p_return_status => l_return_status ,
526: p_msg_count => l_msg_count ,
527: p_msg_data => l_msg_data ,
528: --

Line 544: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

540: p_operation_id => p_operation_id ,
541: p_constraint_set_id => p_constraint_set_id
542: );
543: --
544: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
545: RAISE FND_API.G_EXC_ERROR ;
546: END IF ;
547: --
548: retcode := 0 ;

Line 545: RAISE FND_API.G_EXC_ERROR ;

541: p_constraint_set_id => p_constraint_set_id
542: );
543: --
544: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
545: RAISE FND_API.G_EXC_ERROR ;
546: END IF ;
547: --
548: retcode := 0 ;
549: COMMIT WORK;

Line 553: WHEN FND_API.G_EXC_ERROR THEN

549: COMMIT WORK;
550: --
551: EXCEPTION
552: --
553: WHEN FND_API.G_EXC_ERROR THEN
554: --
555: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
556: p_print_header => FND_API.G_TRUE ) ;
557: retcode := 2 ;

Line 556: p_print_header => FND_API.G_TRUE ) ;

552: --
553: WHEN FND_API.G_EXC_ERROR THEN
554: --
555: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
556: p_print_header => FND_API.G_TRUE ) ;
557: retcode := 2 ;
558: --
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: --

Line 559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

555: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
556: p_print_header => FND_API.G_TRUE ) ;
557: retcode := 2 ;
558: --
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: --
561: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
562: p_print_header => FND_API.G_TRUE ) ;
563: retcode := 2 ;

Line 562: p_print_header => FND_API.G_TRUE ) ;

558: --
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: --
561: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
562: p_print_header => FND_API.G_TRUE ) ;
563: retcode := 2 ;
564: --
565: WHEN OTHERS THEN
566: --

Line 573: p_print_header => FND_API.G_TRUE ) ;

569: l_api_name ) ;
570: END IF ;
571: --
572: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
573: p_print_header => FND_API.G_TRUE ) ;
574: retcode := 2 ;
575: --
576: END Submit_WS ;
577: /*---------------------------------------------------------------------------*/

Line 673: p_init_msg_list => FND_API.G_TRUE,

669: --
670: PSB_WS_Ops_Pvt.Create_Worksheet
671: (
672: p_api_version => 1.0 ,
673: p_init_msg_list => FND_API.G_TRUE,
674: /*For Bug no : 2236283 Start*/
675: --p_commit => FND_API.G_FALSE,
676: p_commit => FND_API.G_TRUE,
677: /*For Bug no : 2236283 End*/

Line 675: --p_commit => FND_API.G_FALSE,

671: (
672: p_api_version => 1.0 ,
673: p_init_msg_list => FND_API.G_TRUE,
674: /*For Bug no : 2236283 Start*/
675: --p_commit => FND_API.G_FALSE,
676: p_commit => FND_API.G_TRUE,
677: /*For Bug no : 2236283 End*/
678: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
679: p_return_status => l_return_status,

Line 676: p_commit => FND_API.G_TRUE,

672: p_api_version => 1.0 ,
673: p_init_msg_list => FND_API.G_TRUE,
674: /*For Bug no : 2236283 Start*/
675: --p_commit => FND_API.G_FALSE,
676: p_commit => FND_API.G_TRUE,
677: /*For Bug no : 2236283 End*/
678: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
679: p_return_status => l_return_status,
680: p_msg_count => l_msg_count,

Line 678: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

674: /*For Bug no : 2236283 Start*/
675: --p_commit => FND_API.G_FALSE,
676: p_commit => FND_API.G_TRUE,
677: /*For Bug no : 2236283 End*/
678: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
679: p_return_status => l_return_status,
680: p_msg_count => l_msg_count,
681: p_msg_data => l_msg_data ,
682: --

Line 688: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

684: p_budget_group_id => p_budget_group_id,
685: p_worksheet_id_OUT => l_child_worksheet_id
686: ) ;
687: --
688: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
690: END IF ;
691: --
692: ELSIF l_child_worksheet_id IS NOT NULL THEN

Line 689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

685: p_worksheet_id_OUT => l_child_worksheet_id
686: ) ;
687: --
688: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
690: END IF ;
691: --
692: ELSIF l_child_worksheet_id IS NOT NULL THEN
693: --

Line 700: p_init_msg_list => FND_API.G_TRUE,

696: --
697: PSB_WS_Ops_Pvt.Update_Worksheet
698: (
699: p_api_version => 1.0 ,
700: p_init_msg_list => FND_API.G_TRUE,
701: p_commit => FND_API.G_FALSE,
702: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
703: p_return_status => l_return_status,
704: p_msg_count => l_msg_count,

Line 701: p_commit => FND_API.G_FALSE,

697: PSB_WS_Ops_Pvt.Update_Worksheet
698: (
699: p_api_version => 1.0 ,
700: p_init_msg_list => FND_API.G_TRUE,
701: p_commit => FND_API.G_FALSE,
702: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
703: p_return_status => l_return_status,
704: p_msg_count => l_msg_count,
705: p_msg_data => l_msg_data,

Line 702: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

698: (
699: p_api_version => 1.0 ,
700: p_init_msg_list => FND_API.G_TRUE,
701: p_commit => FND_API.G_FALSE,
702: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
703: p_return_status => l_return_status,
704: p_msg_count => l_msg_count,
705: p_msg_data => l_msg_data,
706: --

Line 711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

707: p_source_worksheet_id => p_worksheet_id ,
708: p_target_worksheet_id => l_child_worksheet_id
709: );
710: --
711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
713: END IF ;
714: --
715:

Line 712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

708: p_target_worksheet_id => l_child_worksheet_id
709: );
710: --
711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
713: END IF ;
714: --
715:
716: OPEN l_ws_csr ;

Line 728: p_init_msg_list => FND_API.G_FALSE,

724: --
725: PSB_WS_Ops_Pvt.Freeze_Worksheet
726: (
727: p_api_version => 1.0 ,
728: p_init_msg_list => FND_API.G_FALSE,
729: p_commit => FND_API.G_FALSE,
730: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
731: p_return_status => l_return_status,
732: p_msg_count => l_msg_count,

Line 729: p_commit => FND_API.G_FALSE,

725: PSB_WS_Ops_Pvt.Freeze_Worksheet
726: (
727: p_api_version => 1.0 ,
728: p_init_msg_list => FND_API.G_FALSE,
729: p_commit => FND_API.G_FALSE,
730: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
731: p_return_status => l_return_status,
732: p_msg_count => l_msg_count,
733: p_msg_data => l_msg_data,

Line 730: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

726: (
727: p_api_version => 1.0 ,
728: p_init_msg_list => FND_API.G_FALSE,
729: p_commit => FND_API.G_FALSE,
730: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
731: p_return_status => l_return_status,
732: p_msg_count => l_msg_count,
733: p_msg_data => l_msg_data,
734: --

Line 739: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

735: p_worksheet_id => l_child_worksheet_id ,
736: p_freeze_flag => 'N'
737: );
738: --
739: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
741: END IF ;
742: --
743: END IF;

Line 740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

736: p_freeze_flag => 'N'
737: );
738: --
739: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
741: END IF ;
742: --
743: END IF;
744: --

Line 778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

774: FND_MESSAGE.SET_TOKEN('BGROUP', l_bg_short_name);
775: /*For Bug No : 2239422 End*/
776:
777: FND_MSG_PUB.Add ;
778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
779: END IF;
780: CLOSE l_role_csr ;
781:
782:

Line 802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

798: l_budget_group_resp_id
799: ) ;
800:
801: IF (SQL%NOTFOUND) THEN
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
803: END IF;
804:
805: -- Update distributions table
806: UPDATE psb_ws_distributions

Line 815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

811: last_update_login = g_current_login_id
812: WHERE distribution_id = p_distribution_id ;
813:
814: IF (SQL%NOTFOUND) THEN
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
816: END IF;
817:
818:
819: /*---3. WORKFLOW-----------------------------------------------*/

Line 844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

840: 'BP'
841: );
842:
843: IF (SQL%NOTFOUND ) THEN
844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
845: END IF;
846:
847: --
848: -- Start the Workflow 'Distribution Process'.

Line 853: p_init_msg_list => FND_API.G_FALSE,

849: --
850:
851: PSB_Distribute_Worksheet_PVT.Start_Process
852: ( p_api_version => 1.0 ,
853: p_init_msg_list => FND_API.G_FALSE,
854: p_commit => FND_API.G_FALSE,
855: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
856: p_return_status => l_return_status ,
857: p_msg_count => l_msg_count ,

Line 854: p_commit => FND_API.G_FALSE,

850:
851: PSB_Distribute_Worksheet_PVT.Start_Process
852: ( p_api_version => 1.0 ,
853: p_init_msg_list => FND_API.G_FALSE,
854: p_commit => FND_API.G_FALSE,
855: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
856: p_return_status => l_return_status ,
857: p_msg_count => l_msg_count ,
858: p_msg_data => l_msg_data ,

Line 855: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

851: PSB_Distribute_Worksheet_PVT.Start_Process
852: ( p_api_version => 1.0 ,
853: p_init_msg_list => FND_API.G_FALSE,
854: p_commit => FND_API.G_FALSE,
855: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
856: p_return_status => l_return_status ,
857: p_msg_count => l_msg_count ,
858: p_msg_data => l_msg_data ,
859: --

Line 865: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

861: p_distribution_instructions => g_distribution_instructions ,
862: p_recipient_name => l_dist_wf_role_name
863: );
864: --
865: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
867: END IF ;
868: --
869: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

862: p_recipient_name => l_dist_wf_role_name
863: );
864: --
865: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
867: END IF ;
868: --
869: p_return_status := FND_API.G_RET_STS_SUCCESS ;
870: --

Line 869: p_return_status := FND_API.G_RET_STS_SUCCESS ;

865: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
867: END IF ;
868: --
869: p_return_status := FND_API.G_RET_STS_SUCCESS ;
870: --
871: EXCEPTION
872: --
873: WHEN OTHERS THEN

Line 878: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

874: --
875: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
876: 'Create_Worksheet (Private)' );
877: --
878: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879: --
880: END Create_Worksheet;
881: /*---------------------------------------------------------------------------*/
882:

Line 891: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

887: +===========================================================================*/
888: PROCEDURE Generate_Account
889: (
890: p_api_version IN NUMBER ,
891: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
892: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
893: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
894: p_return_status OUT NOCOPY VARCHAR2 ,
895: p_msg_count OUT NOCOPY NUMBER ,

Line 892: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

888: PROCEDURE Generate_Account
889: (
890: p_api_version IN NUMBER ,
891: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
892: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
893: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
894: p_return_status OUT NOCOPY VARCHAR2 ,
895: p_msg_count OUT NOCOPY NUMBER ,
896: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 893: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

889: (
890: p_api_version IN NUMBER ,
891: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
892: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
893: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
894: p_return_status OUT NOCOPY VARCHAR2 ,
895: p_msg_count OUT NOCOPY NUMBER ,
896: p_msg_data OUT NOCOPY VARCHAR2 ,
897: --

Line 906: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,

902: p_expenditure_organization_id
903: IN
904: psb_cost_distributions_i.expenditure_organization_id%TYPE ,
905: p_chart_of_accounts_id IN NUMBER,
906: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
907: p_code_combination_id OUT NOCOPY gl_code_combinations.code_combination_id%TYPE ,
908: p_error_message OUT NOCOPY VARCHAR2
909: )
910: IS

Line 940: IF NOT FND_API.Compatible_API_Call ( l_api_version,

936: BEGIN
937: --
938: SAVEPOINT Generate_Account_Pvt ;
939: --
940: IF NOT FND_API.Compatible_API_Call ( l_api_version,
941: p_api_version,
942: l_api_name,
943: G_PKG_NAME )
944: THEN

Line 945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

941: p_api_version,
942: l_api_name,
943: G_PKG_NAME )
944: THEN
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
946: END IF;
947: --
948:
949: IF FND_API.To_Boolean ( p_init_msg_list ) THEN

Line 949: IF FND_API.To_Boolean ( p_init_msg_list ) THEN

945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
946: END IF;
947: --
948:
949: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
950: FND_MSG_PUB.initialize ;
951: END IF;
952: --
953: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 953: p_return_status := FND_API.G_RET_STS_SUCCESS ;

949: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
950: FND_MSG_PUB.initialize ;
951: END IF;
952: --
953: p_return_status := FND_API.G_RET_STS_SUCCESS ;
954: --
955:
956: pd('Calling initialize with coa_id : ' || p_chart_of_accounts_id);
957:

Line 1004: IF p_description = FND_API.G_MISS_CHAR THEN

1000: -- Populate item attributes based on POETA internal codes.
1001: -----------------------------------------------------------
1002:
1003: -- Resolve optional parameters.
1004: IF p_description = FND_API.G_MISS_CHAR THEN
1005: l_description := NULL;
1006: ELSE
1007: l_description := p_description ;
1008: END IF;

Line 1078: IF FND_API.To_Boolean ( p_commit ) THEN

1074: p_error_message := l_error_message ;
1075: END IF;
1076:
1077: --
1078: IF FND_API.To_Boolean ( p_commit ) THEN
1079: COMMIT WORK;
1080: END IF;
1081: --
1082: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1087: WHEN FND_API.G_EXC_ERROR THEN

1083: p_data => p_msg_data );
1084: --
1085: EXCEPTION
1086: --
1087: WHEN FND_API.G_EXC_ERROR THEN
1088: --
1089: ROLLBACK TO Generate_Account_Pvt ;
1090: p_return_status := FND_API.G_RET_STS_ERROR;
1091: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1090: p_return_status := FND_API.G_RET_STS_ERROR;

1086: --
1087: WHEN FND_API.G_EXC_ERROR THEN
1088: --
1089: ROLLBACK TO Generate_Account_Pvt ;
1090: p_return_status := FND_API.G_RET_STS_ERROR;
1091: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1092: p_data => p_msg_data );
1093: --
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1090: p_return_status := FND_API.G_RET_STS_ERROR;
1091: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1092: p_data => p_msg_data );
1093: --
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: --
1096: ROLLBACK TO Generate_Account_Pvt ;
1097: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1098: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1097: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1093: --
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: --
1096: ROLLBACK TO Generate_Account_Pvt ;
1097: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1098: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1099: p_data => p_msg_data );
1100: --
1101: WHEN OTHERS THEN

Line 1104: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1100: --
1101: WHEN OTHERS THEN
1102: --
1103: ROLLBACK TO Generate_Account_Pvt ;
1104: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1105: --
1106: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1107: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1108: l_api_name);

Line 1222: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1218: Add_Debug_Info('1- WS for BG '||
1219: to_char(l_budget_groups_rec.budget_group_id) ||
1220: ' Status '||l_return_status) ;
1221:
1222: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1223: RAISE FND_API.G_EXC_ERROR ;
1224: END IF ;
1225: --
1226:

Line 1223: RAISE FND_API.G_EXC_ERROR ;

1219: to_char(l_budget_groups_rec.budget_group_id) ||
1220: ' Status '||l_return_status) ;
1221:
1222: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1223: RAISE FND_API.G_EXC_ERROR ;
1224: END IF ;
1225: --
1226:
1227: ELSIF l_budget_groups_rec.distribute_all_level_flag = 'Y' THEN

Line 1253: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1249: p_return_status => l_return_status
1250: );
1251: --
1252:
1253: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1254: RAISE FND_API.G_EXC_ERROR ;
1255: END IF ;
1256: --
1257:

Line 1254: RAISE FND_API.G_EXC_ERROR ;

1250: );
1251: --
1252:
1253: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1254: RAISE FND_API.G_EXC_ERROR ;
1255: END IF ;
1256: --
1257:
1258: END LOOP ; -- To process all the child bgs for the current worksheet.

Line 1270: WHEN FND_API.G_EXC_ERROR THEN

1266: COMMIT WORK;
1267: --
1268: EXCEPTION
1269: --
1270: WHEN FND_API.G_EXC_ERROR THEN
1271: --
1272: ROLLBACK TO Distribute_BR_Pvt ;
1273: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1274: p_print_header => FND_API.G_TRUE ) ;

Line 1274: p_print_header => FND_API.G_TRUE ) ;

1270: WHEN FND_API.G_EXC_ERROR THEN
1271: --
1272: ROLLBACK TO Distribute_BR_Pvt ;
1273: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1274: p_print_header => FND_API.G_TRUE ) ;
1275: retcode := 2 ;
1276: --
1277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1278: --

Line 1277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1273: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1274: p_print_header => FND_API.G_TRUE ) ;
1275: retcode := 2 ;
1276: --
1277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1278: --
1279: ROLLBACK TO Distribute_BR_Pvt ;
1280: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1281: p_print_header => FND_API.G_TRUE ) ;

Line 1281: p_print_header => FND_API.G_TRUE ) ;

1277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1278: --
1279: ROLLBACK TO Distribute_BR_Pvt ;
1280: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1281: p_print_header => FND_API.G_TRUE ) ;
1282: retcode := 2 ;
1283: --
1284: WHEN OTHERS THEN
1285: --

Line 1294: p_print_header => FND_API.G_TRUE ) ;

1290: l_api_name ) ;
1291: END IF ;
1292: --
1293: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1294: p_print_header => FND_API.G_TRUE ) ;
1295: retcode := 2 ;
1296: --
1297: END Distribute_BR ;
1298: /*===========================================================================+

Line 1403: p_init_msg_list => FND_API.G_TRUE,

1399: --
1400: PSB_Create_BR_Pvt.Create_Budget_Revision
1401: (
1402: p_api_version => 1.0 ,
1403: p_init_msg_list => FND_API.G_TRUE,
1404: p_commit => FND_API.G_FALSE,
1405: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1406: p_return_status => l_return_status,
1407: p_msg_count => l_msg_count,

Line 1404: p_commit => FND_API.G_FALSE,

1400: PSB_Create_BR_Pvt.Create_Budget_Revision
1401: (
1402: p_api_version => 1.0 ,
1403: p_init_msg_list => FND_API.G_TRUE,
1404: p_commit => FND_API.G_FALSE,
1405: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1406: p_return_status => l_return_status,
1407: p_msg_count => l_msg_count,
1408: p_msg_data => l_msg_data ,

Line 1405: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1401: (
1402: p_api_version => 1.0 ,
1403: p_init_msg_list => FND_API.G_TRUE,
1404: p_commit => FND_API.G_FALSE,
1405: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1406: p_return_status => l_return_status,
1407: p_msg_count => l_msg_count,
1408: p_msg_data => l_msg_data ,
1409: --

Line 1416: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1412: p_revision_option_flag => l_revision_option_flag,
1413: p_budget_revision_id_out => l_child_budget_revision_id
1414: ) ;
1415: --
1416: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1418: END IF ;
1419: --
1420: ELSIF l_child_budget_revision_id IS NOT NULL THEN

Line 1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1413: p_budget_revision_id_out => l_child_budget_revision_id
1414: ) ;
1415: --
1416: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1418: END IF ;
1419: --
1420: ELSIF l_child_budget_revision_id IS NOT NULL THEN
1421: --

Line 1428: p_init_msg_list => FND_API.G_TRUE,

1424: --
1425: PSB_Create_BR_Pvt.Update_Target_Budget_Revision
1426: (
1427: p_api_version => 1.0 ,
1428: p_init_msg_list => FND_API.G_TRUE,
1429: p_commit => FND_API.G_FALSE,
1430: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1431: p_return_status => l_return_status,
1432: p_msg_count => l_msg_count,

Line 1429: p_commit => FND_API.G_FALSE,

1425: PSB_Create_BR_Pvt.Update_Target_Budget_Revision
1426: (
1427: p_api_version => 1.0 ,
1428: p_init_msg_list => FND_API.G_TRUE,
1429: p_commit => FND_API.G_FALSE,
1430: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1431: p_return_status => l_return_status,
1432: p_msg_count => l_msg_count,
1433: p_msg_data => l_msg_data,

Line 1430: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1426: (
1427: p_api_version => 1.0 ,
1428: p_init_msg_list => FND_API.G_TRUE,
1429: p_commit => FND_API.G_FALSE,
1430: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1431: p_return_status => l_return_status,
1432: p_msg_count => l_msg_count,
1433: p_msg_data => l_msg_data,
1434: --

Line 1440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1436: p_revision_option_flag => l_revision_option_flag,
1437: p_target_budget_revision_id => l_child_budget_revision_id
1438: );
1439: --
1440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1442: END IF ;
1443: --
1444:

Line 1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1437: p_target_budget_revision_id => l_child_budget_revision_id
1438: );
1439: --
1440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1442: END IF ;
1443: --
1444:
1445:

Line 1460: p_init_msg_list => FND_API.G_FALSE,

1456: --
1457: PSB_Create_BR_Pvt.Freeze_Budget_Revision
1458: (
1459: p_api_version => 1.0 ,
1460: p_init_msg_list => FND_API.G_FALSE,
1461: p_commit => FND_API.G_FALSE,
1462: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1463: p_return_status => l_return_status,
1464: p_msg_count => l_msg_count,

Line 1461: p_commit => FND_API.G_FALSE,

1457: PSB_Create_BR_Pvt.Freeze_Budget_Revision
1458: (
1459: p_api_version => 1.0 ,
1460: p_init_msg_list => FND_API.G_FALSE,
1461: p_commit => FND_API.G_FALSE,
1462: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1463: p_return_status => l_return_status,
1464: p_msg_count => l_msg_count,
1465: p_msg_data => l_msg_data,

Line 1462: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1458: (
1459: p_api_version => 1.0 ,
1460: p_init_msg_list => FND_API.G_FALSE,
1461: p_commit => FND_API.G_FALSE,
1462: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1463: p_return_status => l_return_status,
1464: p_msg_count => l_msg_count,
1465: p_msg_data => l_msg_data,
1466: --

Line 1471: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1467: p_budget_revision_id => l_child_budget_revision_id,
1468: p_freeze_flag => 'N'
1469: );
1470: --
1471: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1473: END IF ;
1474: --
1475: END IF;

Line 1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1468: p_freeze_flag => 'N'
1469: );
1470: --
1471: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1473: END IF ;
1474: --
1475: END IF;
1476: --

Line 1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1507: FND_MESSAGE.SET_TOKEN('BGROUP', l_bg_short_name);
1508: /*For Bug No : 2239422 End*/
1509:
1510: FND_MSG_PUB.Add ;
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1512: END IF;
1513: CLOSE l_role_csr ;
1514:
1515:

Line 1535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1531: l_budget_group_resp_id
1532: ) ;
1533:
1534: IF (SQL%NOTFOUND) THEN
1535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1536: END IF;
1537:
1538: -- Update distributions table
1539: UPDATE psb_ws_distributions

Line 1548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1544: last_update_login = g_current_login_id
1545: WHERE distribution_id = p_distribution_id ;
1546:
1547: IF (SQL%NOTFOUND) THEN
1548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1549: END IF;
1550:
1551:
1552: /*---3. WORKFLOW-----------------------------------------------*/

Line 1577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1573: 'BR'
1574: );
1575:
1576: IF (SQL%NOTFOUND ) THEN
1577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1578: END IF;
1579:
1580: --
1581: -- Start the Workflow 'Distribution Process'.

Line 1586: p_init_msg_list => FND_API.G_FALSE,

1582: --
1583:
1584: PSB_Submit_Revision_Pvt.Start_Distribution_Process
1585: ( p_api_version => 1.0 ,
1586: p_init_msg_list => FND_API.G_FALSE,
1587: p_commit => FND_API.G_FALSE,
1588: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1589: p_return_status => l_return_status ,
1590: p_msg_count => l_msg_count ,

Line 1587: p_commit => FND_API.G_FALSE,

1583:
1584: PSB_Submit_Revision_Pvt.Start_Distribution_Process
1585: ( p_api_version => 1.0 ,
1586: p_init_msg_list => FND_API.G_FALSE,
1587: p_commit => FND_API.G_FALSE,
1588: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1589: p_return_status => l_return_status ,
1590: p_msg_count => l_msg_count ,
1591: p_msg_data => l_msg_data ,

Line 1588: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1584: PSB_Submit_Revision_Pvt.Start_Distribution_Process
1585: ( p_api_version => 1.0 ,
1586: p_init_msg_list => FND_API.G_FALSE,
1587: p_commit => FND_API.G_FALSE,
1588: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1589: p_return_status => l_return_status ,
1590: p_msg_count => l_msg_count ,
1591: p_msg_data => l_msg_data ,
1592: --

Line 1598: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1594: p_distribution_instructions => g_distribution_instructions ,
1595: p_recipient_name => l_dist_wf_role_name
1596: );
1597: --
1598: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1600: END IF ;
1601: --
1602: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1595: p_recipient_name => l_dist_wf_role_name
1596: );
1597: --
1598: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1600: END IF ;
1601: --
1602: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1603: --

Line 1602: p_return_status := FND_API.G_RET_STS_SUCCESS ;

1598: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1600: END IF ;
1601: --
1602: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1603: --
1604: EXCEPTION
1605: --
1606: WHEN OTHERS THEN

Line 1611: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1607: --
1608: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1609: 'Distribute_Budget_Revision (Private)' );
1610: --
1611: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1612: --
1613: END Distribute_Budget_Revision;
1614:
1615:

Line 1664: p_init_msg_list => FND_API.G_FALSE ,

1660:
1661: /*PSB_Create_BR_Pvt.Check_BR_Ops_Concurrency
1662: (
1663: p_api_version => 1.0 ,
1664: p_init_msg_list => FND_API.G_FALSE ,
1665: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
1666: p_return_status => l_return_status ,
1667: p_msg_count => l_msg_count ,
1668: p_msg_data => l_msg_data ,

Line 1665: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,

1661: /*PSB_Create_BR_Pvt.Check_BR_Ops_Concurrency
1662: (
1663: p_api_version => 1.0 ,
1664: p_init_msg_list => FND_API.G_FALSE ,
1665: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
1666: p_return_status => l_return_status ,
1667: p_msg_count => l_msg_count ,
1668: p_msg_data => l_msg_data ,
1669: --

Line 1674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1670: p_budget_revision_id => p_budget_revision_id ,
1671: p_operation_type => p_operation_type
1672: );
1673: --
1674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1675: FND_MSG_PUB.Add_Exc_Msg( 'PSB_BR_Ops_Pvt', 'Check_BR_Ops_Concurrency') ;
1676: RAISE FND_API.G_EXC_ERROR ;
1677: END IF ; */
1678: --

Line 1676: RAISE FND_API.G_EXC_ERROR ;

1672: );
1673: --
1674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1675: FND_MSG_PUB.Add_Exc_Msg( 'PSB_BR_Ops_Pvt', 'Check_BR_Ops_Concurrency') ;
1676: RAISE FND_API.G_EXC_ERROR ;
1677: END IF ; */
1678: --
1679:
1680: --

Line 1727: p_init_msg_list => FND_API.G_FALSE,

1723: --
1724:
1725: PSB_Submit_Revision_PVT.Start_Process
1726: ( p_api_version => 1.0 ,
1727: p_init_msg_list => FND_API.G_FALSE,
1728: p_commit => FND_API.G_FALSE,
1729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1730: p_return_status => l_return_status ,
1731: p_msg_count => l_msg_count ,

Line 1728: p_commit => FND_API.G_FALSE,

1724:
1725: PSB_Submit_Revision_PVT.Start_Process
1726: ( p_api_version => 1.0 ,
1727: p_init_msg_list => FND_API.G_FALSE,
1728: p_commit => FND_API.G_FALSE,
1729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1730: p_return_status => l_return_status ,
1731: p_msg_count => l_msg_count ,
1732: p_msg_data => l_msg_data ,

Line 1729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1725: PSB_Submit_Revision_PVT.Start_Process
1726: ( p_api_version => 1.0 ,
1727: p_init_msg_list => FND_API.G_FALSE,
1728: p_commit => FND_API.G_FALSE,
1729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1730: p_return_status => l_return_status ,
1731: p_msg_count => l_msg_count ,
1732: p_msg_data => l_msg_data ,
1733: --

Line 1744: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1740: p_operation_id => p_operation_id ,
1741: p_constraint_set_id => p_constraint_set_id
1742: );
1743: --
1744: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1745: RAISE FND_API.G_EXC_ERROR ;
1746: END IF ;
1747: --
1748: retcode := 0 ;

Line 1745: RAISE FND_API.G_EXC_ERROR ;

1741: p_constraint_set_id => p_constraint_set_id
1742: );
1743: --
1744: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1745: RAISE FND_API.G_EXC_ERROR ;
1746: END IF ;
1747: --
1748: retcode := 0 ;
1749:

Line 1754: WHEN FND_API.G_EXC_ERROR THEN

1750: COMMIT WORK;
1751: --
1752: EXCEPTION
1753: --
1754: WHEN FND_API.G_EXC_ERROR THEN
1755: --
1756: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1757: p_print_header => FND_API.G_TRUE ) ;
1758: retcode := 2 ;

Line 1757: p_print_header => FND_API.G_TRUE ) ;

1753: --
1754: WHEN FND_API.G_EXC_ERROR THEN
1755: --
1756: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1757: p_print_header => FND_API.G_TRUE ) ;
1758: retcode := 2 ;
1759: --
1760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1761: --

Line 1760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1756: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1757: p_print_header => FND_API.G_TRUE ) ;
1758: retcode := 2 ;
1759: --
1760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1761: --
1762: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1763: p_print_header => FND_API.G_TRUE ) ;
1764: retcode := 2 ;

Line 1763: p_print_header => FND_API.G_TRUE ) ;

1759: --
1760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1761: --
1762: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1763: p_print_header => FND_API.G_TRUE ) ;
1764: retcode := 2 ;
1765: --
1766: WHEN OTHERS THEN
1767: --

Line 1775: p_print_header => FND_API.G_TRUE ) ;

1771: l_api_name ) ;
1772: END IF ;
1773: --
1774: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1775: p_print_header => FND_API.G_TRUE ) ;
1776: retcode := 2 ;
1777: --
1778: END Submit_BR ;
1779: /*---------------------------------------------------------------------------*/