2351: begin
2352:
2353: -- SetOrgContext (p_item_key);
2354:
2355: -- Bug 2105483 : rather then calling arp_global at the start
2356: -- of the package, where it can error out NOCOPY since org_id is not yet set,
2357: -- do the call right before it is needed
2358: arp_global.init_global;
2359: CRLF := arp_global.CRLF;
2354:
2355: -- Bug 2105483 : rather then calling arp_global at the start
2356: -- of the package, where it can error out NOCOPY since org_id is not yet set,
2357: -- do the call right before it is needed
2358: arp_global.init_global;
2359: CRLF := arp_global.CRLF;
2360:
2361: --
2362: -- RUN mode - normal process execution
2355: -- Bug 2105483 : rather then calling arp_global at the start
2356: -- of the package, where it can error out NOCOPY since org_id is not yet set,
2357: -- do the call right before it is needed
2358: arp_global.init_global;
2359: CRLF := arp_global.CRLF;
2360:
2361: --
2362: -- RUN mode - normal process execution
2363: --
2634:
2635: begin
2636: SetOrgContext (p_item_key);
2637:
2638: -- Bug 2105483 : rather then calling arp_global at the start
2639: -- of the package, where it can error out NOCOPY since org_id is not yet set,
2640: -- do the call right before it is needed
2641: arp_global.init_global;
2642: CRLF := arp_global.CRLF;
2637:
2638: -- Bug 2105483 : rather then calling arp_global at the start
2639: -- of the package, where it can error out NOCOPY since org_id is not yet set,
2640: -- do the call right before it is needed
2641: arp_global.init_global;
2642: CRLF := arp_global.CRLF;
2643:
2644: --
2645: -- RUN mode - normal process execution
2638: -- Bug 2105483 : rather then calling arp_global at the start
2639: -- of the package, where it can error out NOCOPY since org_id is not yet set,
2640: -- do the call right before it is needed
2641: arp_global.init_global;
2642: CRLF := arp_global.CRLF;
2643:
2644: --
2645: -- RUN mode - normal process execution
2646: --
3790:
3791: BEGIN
3792: -- SetOrgContext (p_item_key);
3793:
3794: -- Bug 2105483 : rather then calling arp_global at the start
3795: -- of the package, where it can error out NOCOPY since org_id is not yet set,
3796: -- do the call right before it is needed
3797: arp_global.init_global;
3798:
3793:
3794: -- Bug 2105483 : rather then calling arp_global at the start
3795: -- of the package, where it can error out NOCOPY since org_id is not yet set,
3796: -- do the call right before it is needed
3797: arp_global.init_global;
3798:
3799: /* Bug 1908252 */
3800: l_last_updated_by := ARP_GLOBAL.user_id;
3801: l_last_update_login := ARP_GLOBAL.last_update_login ;
3796: -- do the call right before it is needed
3797: arp_global.init_global;
3798:
3799: /* Bug 1908252 */
3800: l_last_updated_by := ARP_GLOBAL.user_id;
3801: l_last_update_login := ARP_GLOBAL.last_update_login ;
3802:
3803: ---------------------------------------------------------------------
3804: l_debug_mesg := 'Insert Completed Manual Entry notes';
3797: arp_global.init_global;
3798:
3799: /* Bug 1908252 */
3800: l_last_updated_by := ARP_GLOBAL.user_id;
3801: l_last_update_login := ARP_GLOBAL.last_update_login ;
3802:
3803: ---------------------------------------------------------------------
3804: l_debug_mesg := 'Insert Completed Manual Entry notes';
3805: ---------------------------------------------------------------------
4113:
4114: BEGIN
4115: -- SetOrgContext (p_item_key);
4116:
4117: -- Bug 2105483 : rather then calling arp_global at the start
4118: -- of the package, where it can error out NOCOPY since org_id is not yet set,
4119: -- do the call right before it is needed
4120: arp_global.init_global;
4121:
4116:
4117: -- Bug 2105483 : rather then calling arp_global at the start
4118: -- of the package, where it can error out NOCOPY since org_id is not yet set,
4119: -- do the call right before it is needed
4120: arp_global.init_global;
4121:
4122: /* Bug 1908252 */
4123: l_last_updated_by := ARP_GLOBAL.user_id;
4124: l_last_update_login := ARP_GLOBAL.last_update_login ;
4119: -- do the call right before it is needed
4120: arp_global.init_global;
4121:
4122: /* Bug 1908252 */
4123: l_last_updated_by := ARP_GLOBAL.user_id;
4124: l_last_update_login := ARP_GLOBAL.last_update_login ;
4125:
4126: ---------------------------------------------------------------------
4127: l_debug_mesg := 'Insert Rejected Response notes';
4120: arp_global.init_global;
4121:
4122: /* Bug 1908252 */
4123: l_last_updated_by := ARP_GLOBAL.user_id;
4124: l_last_update_login := ARP_GLOBAL.last_update_login ;
4125:
4126: ---------------------------------------------------------------------
4127: l_debug_mesg := 'Insert Rejected Response notes';
4128: ---------------------------------------------------------------------
4455: ---------------------------------------------------------------------------
4456: l_debug_mesg := 'Insert call topic notes';
4457: ---------------------------------------------------------------------------
4458:
4459: -- Bug 2105483 : rather then calling arp_global at the start
4460: -- of the package, where it can error out NOCOPY since org_id is not yet set,
4461: -- do the call right before it is needed
4462: arp_global.init_global;
4463:
4458:
4459: -- Bug 2105483 : rather then calling arp_global at the start
4460: -- of the package, where it can error out NOCOPY since org_id is not yet set,
4461: -- do the call right before it is needed
4462: arp_global.init_global;
4463:
4464: -- call a server side package
4465:
4466: /* Bug 1690118 : replace FND_GLOBAL with ARP_GLOBAL */
4462: arp_global.init_global;
4463:
4464: -- call a server side package
4465:
4466: /* Bug 1690118 : replace FND_GLOBAL with ARP_GLOBAL */
4467:
4468: l_created_by := ARP_GLOBAL.USER_ID;
4469: l_creation_date := sysdate;
4470: l_last_update_login := ARP_GLOBAL.last_update_login ;
4464: -- call a server side package
4465:
4466: /* Bug 1690118 : replace FND_GLOBAL with ARP_GLOBAL */
4467:
4468: l_created_by := ARP_GLOBAL.USER_ID;
4469: l_creation_date := sysdate;
4470: l_last_update_login := ARP_GLOBAL.last_update_login ;
4471: l_last_update_date := sysdate;
4472: l_last_updated_by := ARP_GLOBAL.USER_ID;
4466: /* Bug 1690118 : replace FND_GLOBAL with ARP_GLOBAL */
4467:
4468: l_created_by := ARP_GLOBAL.USER_ID;
4469: l_creation_date := sysdate;
4470: l_last_update_login := ARP_GLOBAL.last_update_login ;
4471: l_last_update_date := sysdate;
4472: l_last_updated_by := ARP_GLOBAL.USER_ID;
4473:
4474: arp_notes_pkg.insert_cover(
4468: l_created_by := ARP_GLOBAL.USER_ID;
4469: l_creation_date := sysdate;
4470: l_last_update_login := ARP_GLOBAL.last_update_login ;
4471: l_last_update_date := sysdate;
4472: l_last_updated_by := ARP_GLOBAL.USER_ID;
4473:
4474: arp_notes_pkg.insert_cover(
4475: p_note_type => x_note_type,
4476: p_text => x_text,
4537:
4538: BEGIN
4539: SetOrgContext (p_item_key);
4540:
4541: -- Bug 2105483 : rather then calling arp_global at the start
4542: -- of the package, where it can error out NOCOPY since org_id is not yet set,
4543: -- do the call right before it is needed
4544: arp_global.init_global;
4545:
4540:
4541: -- Bug 2105483 : rather then calling arp_global at the start
4542: -- of the package, where it can error out NOCOPY since org_id is not yet set,
4543: -- do the call right before it is needed
4544: arp_global.init_global;
4545:
4546: crlf := arp_global.CRLF;
4547:
4548: /* Bug 1908252 */
4542: -- of the package, where it can error out NOCOPY since org_id is not yet set,
4543: -- do the call right before it is needed
4544: arp_global.init_global;
4545:
4546: crlf := arp_global.CRLF;
4547:
4548: /* Bug 1908252 */
4549: l_last_updated_by := ARP_GLOBAL.user_id;
4550: l_last_update_login := ARP_GLOBAL.last_update_login ;
4545:
4546: crlf := arp_global.CRLF;
4547:
4548: /* Bug 1908252 */
4549: l_last_updated_by := ARP_GLOBAL.user_id;
4550: l_last_update_login := ARP_GLOBAL.last_update_login ;
4551:
4552: --
4553: -- RUN mode - normal process execution
4546: crlf := arp_global.CRLF;
4547:
4548: /* Bug 1908252 */
4549: l_last_updated_by := ARP_GLOBAL.user_id;
4550: l_last_update_login := ARP_GLOBAL.last_update_login ;
4551:
4552: --
4553: -- RUN mode - normal process execution
4554: --