2310: begin
2311:
2312: -- SetOrgContext (p_item_key);
2313:
2314: -- Bug 2105483 : rather then calling arp_global at the start
2315: -- of the package, where it can error out NOCOPY since org_id is not yet set,
2316: -- do the call right before it is needed
2317: arp_global.init_global;
2318: CRLF := arp_global.CRLF;
2313:
2314: -- Bug 2105483 : rather then calling arp_global at the start
2315: -- of the package, where it can error out NOCOPY since org_id is not yet set,
2316: -- do the call right before it is needed
2317: arp_global.init_global;
2318: CRLF := arp_global.CRLF;
2319:
2320: --
2321: -- RUN mode - normal process execution
2314: -- Bug 2105483 : rather then calling arp_global at the start
2315: -- of the package, where it can error out NOCOPY since org_id is not yet set,
2316: -- do the call right before it is needed
2317: arp_global.init_global;
2318: CRLF := arp_global.CRLF;
2319:
2320: --
2321: -- RUN mode - normal process execution
2322: --
2593:
2594: begin
2595: SetOrgContext (p_item_key);
2596:
2597: -- Bug 2105483 : rather then calling arp_global at the start
2598: -- of the package, where it can error out NOCOPY since org_id is not yet set,
2599: -- do the call right before it is needed
2600: arp_global.init_global;
2601: CRLF := arp_global.CRLF;
2596:
2597: -- Bug 2105483 : rather then calling arp_global at the start
2598: -- of the package, where it can error out NOCOPY since org_id is not yet set,
2599: -- do the call right before it is needed
2600: arp_global.init_global;
2601: CRLF := arp_global.CRLF;
2602:
2603: --
2604: -- RUN mode - normal process execution
2597: -- Bug 2105483 : rather then calling arp_global at the start
2598: -- of the package, where it can error out NOCOPY since org_id is not yet set,
2599: -- do the call right before it is needed
2600: arp_global.init_global;
2601: CRLF := arp_global.CRLF;
2602:
2603: --
2604: -- RUN mode - normal process execution
2605: --
3683:
3684: BEGIN
3685: -- SetOrgContext (p_item_key);
3686:
3687: -- Bug 2105483 : rather then calling arp_global at the start
3688: -- of the package, where it can error out NOCOPY since org_id is not yet set,
3689: -- do the call right before it is needed
3690: arp_global.init_global;
3691:
3686:
3687: -- Bug 2105483 : rather then calling arp_global at the start
3688: -- of the package, where it can error out NOCOPY since org_id is not yet set,
3689: -- do the call right before it is needed
3690: arp_global.init_global;
3691:
3692: /* Bug 1908252 */
3693: l_last_updated_by := ARP_GLOBAL.user_id;
3694: l_last_update_login := ARP_GLOBAL.last_update_login ;
3689: -- do the call right before it is needed
3690: arp_global.init_global;
3691:
3692: /* Bug 1908252 */
3693: l_last_updated_by := ARP_GLOBAL.user_id;
3694: l_last_update_login := ARP_GLOBAL.last_update_login ;
3695:
3696: ---------------------------------------------------------------------
3697: l_debug_mesg := 'Insert Completed Manual Entry notes';
3690: arp_global.init_global;
3691:
3692: /* Bug 1908252 */
3693: l_last_updated_by := ARP_GLOBAL.user_id;
3694: l_last_update_login := ARP_GLOBAL.last_update_login ;
3695:
3696: ---------------------------------------------------------------------
3697: l_debug_mesg := 'Insert Completed Manual Entry notes';
3698: ---------------------------------------------------------------------
4006:
4007: BEGIN
4008: -- SetOrgContext (p_item_key);
4009:
4010: -- Bug 2105483 : rather then calling arp_global at the start
4011: -- of the package, where it can error out NOCOPY since org_id is not yet set,
4012: -- do the call right before it is needed
4013: arp_global.init_global;
4014:
4009:
4010: -- Bug 2105483 : rather then calling arp_global at the start
4011: -- of the package, where it can error out NOCOPY since org_id is not yet set,
4012: -- do the call right before it is needed
4013: arp_global.init_global;
4014:
4015: /* Bug 1908252 */
4016: l_last_updated_by := ARP_GLOBAL.user_id;
4017: l_last_update_login := ARP_GLOBAL.last_update_login ;
4012: -- do the call right before it is needed
4013: arp_global.init_global;
4014:
4015: /* Bug 1908252 */
4016: l_last_updated_by := ARP_GLOBAL.user_id;
4017: l_last_update_login := ARP_GLOBAL.last_update_login ;
4018:
4019: ---------------------------------------------------------------------
4020: l_debug_mesg := 'Insert Rejected Response notes';
4013: arp_global.init_global;
4014:
4015: /* Bug 1908252 */
4016: l_last_updated_by := ARP_GLOBAL.user_id;
4017: l_last_update_login := ARP_GLOBAL.last_update_login ;
4018:
4019: ---------------------------------------------------------------------
4020: l_debug_mesg := 'Insert Rejected Response notes';
4021: ---------------------------------------------------------------------
4348: ---------------------------------------------------------------------------
4349: l_debug_mesg := 'Insert call topic notes';
4350: ---------------------------------------------------------------------------
4351:
4352: -- Bug 2105483 : rather then calling arp_global at the start
4353: -- of the package, where it can error out NOCOPY since org_id is not yet set,
4354: -- do the call right before it is needed
4355: arp_global.init_global;
4356:
4351:
4352: -- Bug 2105483 : rather then calling arp_global at the start
4353: -- of the package, where it can error out NOCOPY since org_id is not yet set,
4354: -- do the call right before it is needed
4355: arp_global.init_global;
4356:
4357: -- call a server side package
4358:
4359: /* Bug 1690118 : replace FND_GLOBAL with ARP_GLOBAL */
4355: arp_global.init_global;
4356:
4357: -- call a server side package
4358:
4359: /* Bug 1690118 : replace FND_GLOBAL with ARP_GLOBAL */
4360:
4361: l_created_by := ARP_GLOBAL.USER_ID;
4362: l_creation_date := sysdate;
4363: l_last_update_login := ARP_GLOBAL.last_update_login ;
4357: -- call a server side package
4358:
4359: /* Bug 1690118 : replace FND_GLOBAL with ARP_GLOBAL */
4360:
4361: l_created_by := ARP_GLOBAL.USER_ID;
4362: l_creation_date := sysdate;
4363: l_last_update_login := ARP_GLOBAL.last_update_login ;
4364: l_last_update_date := sysdate;
4365: l_last_updated_by := ARP_GLOBAL.USER_ID;
4359: /* Bug 1690118 : replace FND_GLOBAL with ARP_GLOBAL */
4360:
4361: l_created_by := ARP_GLOBAL.USER_ID;
4362: l_creation_date := sysdate;
4363: l_last_update_login := ARP_GLOBAL.last_update_login ;
4364: l_last_update_date := sysdate;
4365: l_last_updated_by := ARP_GLOBAL.USER_ID;
4366:
4367: arp_notes_pkg.insert_cover(
4361: l_created_by := ARP_GLOBAL.USER_ID;
4362: l_creation_date := sysdate;
4363: l_last_update_login := ARP_GLOBAL.last_update_login ;
4364: l_last_update_date := sysdate;
4365: l_last_updated_by := ARP_GLOBAL.USER_ID;
4366:
4367: arp_notes_pkg.insert_cover(
4368: p_note_type => x_note_type,
4369: p_text => x_text,
4415:
4416: BEGIN
4417: SetOrgContext (p_item_key);
4418:
4419: -- Bug 2105483 : rather then calling arp_global at the start
4420: -- of the package, where it can error out NOCOPY since org_id is not yet set,
4421: -- do the call right before it is needed
4422: arp_global.init_global;
4423:
4418:
4419: -- Bug 2105483 : rather then calling arp_global at the start
4420: -- of the package, where it can error out NOCOPY since org_id is not yet set,
4421: -- do the call right before it is needed
4422: arp_global.init_global;
4423:
4424: crlf := arp_global.CRLF;
4425:
4426: /* Bug 1908252 */
4420: -- of the package, where it can error out NOCOPY since org_id is not yet set,
4421: -- do the call right before it is needed
4422: arp_global.init_global;
4423:
4424: crlf := arp_global.CRLF;
4425:
4426: /* Bug 1908252 */
4427: l_last_updated_by := ARP_GLOBAL.user_id;
4428: l_last_update_login := ARP_GLOBAL.last_update_login ;
4423:
4424: crlf := arp_global.CRLF;
4425:
4426: /* Bug 1908252 */
4427: l_last_updated_by := ARP_GLOBAL.user_id;
4428: l_last_update_login := ARP_GLOBAL.last_update_login ;
4429:
4430: --
4431: -- RUN mode - normal process execution
4424: crlf := arp_global.CRLF;
4425:
4426: /* Bug 1908252 */
4427: l_last_updated_by := ARP_GLOBAL.user_id;
4428: l_last_update_login := ARP_GLOBAL.last_update_login ;
4429:
4430: --
4431: -- RUN mode - normal process execution
4432: --