DBA Data[Home] [Help]

APPS.GME_MAKE_TO_ORDER_PVT dependencies on FND_GLOBAL

Line 19: | Call FND_GLOBAL.apps_initialize with proper values not hard coded -1.|

15: | |
16: | HISTORY |
17: | Dec, 2007 Srinivasulu Puri Created |
18: | 01-APR-2010 G. Muratore Bug 9355688 |
19: | Call FND_GLOBAL.apps_initialize with proper values not hard coded -1.|
20: | |
21: | 27-JUN-2011 G. Muratore Bug 12664771 |
22: | Do not initialize plan start date. |
23: | 9-FEB-2012 Archana Mundhe Bug 13359707 |

Line 633: -- l_user_id := FND_GLOBAL.user_id;

629: l_batch_header_rec.plan_cmplt_date := l_so_line_rec.schedule_ship_date;
630: /* Batch Creation user. If diff. from the sales order user then set the user context to this one */
631:
632: -- Bug 9355688 - Initialize with proper values not hard coded -1.
633: -- l_user_id := FND_GLOBAL.user_id;
634: -- FND_GLOBAL.apps_initialize(l_user_id,-1,-1);
635:
636: IF (g_debug <= gme_debug.g_log_statement) THEN
637: gme_debug.put_line ('before apps init FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);

Line 634: -- FND_GLOBAL.apps_initialize(l_user_id,-1,-1);

630: /* Batch Creation user. If diff. from the sales order user then set the user context to this one */
631:
632: -- Bug 9355688 - Initialize with proper values not hard coded -1.
633: -- l_user_id := FND_GLOBAL.user_id;
634: -- FND_GLOBAL.apps_initialize(l_user_id,-1,-1);
635:
636: IF (g_debug <= gme_debug.g_log_statement) THEN
637: gme_debug.put_line ('before apps init FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);
638: gme_debug.put_line ('before apps init FND_GLOBAL.RESP_ID '||FND_GLOBAL.RESP_ID);

Line 637: gme_debug.put_line ('before apps init FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);

633: -- l_user_id := FND_GLOBAL.user_id;
634: -- FND_GLOBAL.apps_initialize(l_user_id,-1,-1);
635:
636: IF (g_debug <= gme_debug.g_log_statement) THEN
637: gme_debug.put_line ('before apps init FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);
638: gme_debug.put_line ('before apps init FND_GLOBAL.RESP_ID '||FND_GLOBAL.RESP_ID);
639: gme_debug.put_line ('before apps init FND_GLOBAL.RESP_APPL_ID '||FND_GLOBAL.RESP_APPL_ID);
640: END IF;
641:

Line 638: gme_debug.put_line ('before apps init FND_GLOBAL.RESP_ID '||FND_GLOBAL.RESP_ID);

634: -- FND_GLOBAL.apps_initialize(l_user_id,-1,-1);
635:
636: IF (g_debug <= gme_debug.g_log_statement) THEN
637: gme_debug.put_line ('before apps init FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);
638: gme_debug.put_line ('before apps init FND_GLOBAL.RESP_ID '||FND_GLOBAL.RESP_ID);
639: gme_debug.put_line ('before apps init FND_GLOBAL.RESP_APPL_ID '||FND_GLOBAL.RESP_APPL_ID);
640: END IF;
641:
642: l_user_id := FND_GLOBAL.USER_ID;

Line 639: gme_debug.put_line ('before apps init FND_GLOBAL.RESP_APPL_ID '||FND_GLOBAL.RESP_APPL_ID);

635:
636: IF (g_debug <= gme_debug.g_log_statement) THEN
637: gme_debug.put_line ('before apps init FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);
638: gme_debug.put_line ('before apps init FND_GLOBAL.RESP_ID '||FND_GLOBAL.RESP_ID);
639: gme_debug.put_line ('before apps init FND_GLOBAL.RESP_APPL_ID '||FND_GLOBAL.RESP_APPL_ID);
640: END IF;
641:
642: l_user_id := FND_GLOBAL.USER_ID;
643: l_resp_id := FND_GLOBAL.RESP_ID;

Line 642: l_user_id := FND_GLOBAL.USER_ID;

638: gme_debug.put_line ('before apps init FND_GLOBAL.RESP_ID '||FND_GLOBAL.RESP_ID);
639: gme_debug.put_line ('before apps init FND_GLOBAL.RESP_APPL_ID '||FND_GLOBAL.RESP_APPL_ID);
640: END IF;
641:
642: l_user_id := FND_GLOBAL.USER_ID;
643: l_resp_id := FND_GLOBAL.RESP_ID;
644: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
645:
646: FND_GLOBAL.apps_initialize(user_id => l_user_id,

Line 643: l_resp_id := FND_GLOBAL.RESP_ID;

639: gme_debug.put_line ('before apps init FND_GLOBAL.RESP_APPL_ID '||FND_GLOBAL.RESP_APPL_ID);
640: END IF;
641:
642: l_user_id := FND_GLOBAL.USER_ID;
643: l_resp_id := FND_GLOBAL.RESP_ID;
644: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
645:
646: FND_GLOBAL.apps_initialize(user_id => l_user_id,
647: resp_id => l_resp_id,

Line 644: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

640: END IF;
641:
642: l_user_id := FND_GLOBAL.USER_ID;
643: l_resp_id := FND_GLOBAL.RESP_ID;
644: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
645:
646: FND_GLOBAL.apps_initialize(user_id => l_user_id,
647: resp_id => l_resp_id,
648: resp_appl_id => l_resp_appl_id);

Line 646: FND_GLOBAL.apps_initialize(user_id => l_user_id,

642: l_user_id := FND_GLOBAL.USER_ID;
643: l_resp_id := FND_GLOBAL.RESP_ID;
644: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
645:
646: FND_GLOBAL.apps_initialize(user_id => l_user_id,
647: resp_id => l_resp_id,
648: resp_appl_id => l_resp_appl_id);
649:
650: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 651: gme_debug.put_line ('after apps init FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);

647: resp_id => l_resp_id,
648: resp_appl_id => l_resp_appl_id);
649:
650: IF (g_debug <= gme_debug.g_log_statement) THEN
651: gme_debug.put_line ('after apps init FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);
652: gme_debug.put_line ('after apps init FND_GLOBAL.RESP_ID '||FND_GLOBAL.RESP_ID);
653: gme_debug.put_line ('after apps init FND_GLOBAL.RESP_APPL_ID '||FND_GLOBAL.RESP_APPL_ID);
654: END IF;
655:

Line 652: gme_debug.put_line ('after apps init FND_GLOBAL.RESP_ID '||FND_GLOBAL.RESP_ID);

648: resp_appl_id => l_resp_appl_id);
649:
650: IF (g_debug <= gme_debug.g_log_statement) THEN
651: gme_debug.put_line ('after apps init FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);
652: gme_debug.put_line ('after apps init FND_GLOBAL.RESP_ID '||FND_GLOBAL.RESP_ID);
653: gme_debug.put_line ('after apps init FND_GLOBAL.RESP_APPL_ID '||FND_GLOBAL.RESP_APPL_ID);
654: END IF;
655:
656: IF l_mto_rules_rec.batch_creation_user is not NULL THEN

Line 653: gme_debug.put_line ('after apps init FND_GLOBAL.RESP_APPL_ID '||FND_GLOBAL.RESP_APPL_ID);

649:
650: IF (g_debug <= gme_debug.g_log_statement) THEN
651: gme_debug.put_line ('after apps init FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);
652: gme_debug.put_line ('after apps init FND_GLOBAL.RESP_ID '||FND_GLOBAL.RESP_ID);
653: gme_debug.put_line ('after apps init FND_GLOBAL.RESP_APPL_ID '||FND_GLOBAL.RESP_APPL_ID);
654: END IF;
655:
656: IF l_mto_rules_rec.batch_creation_user is not NULL THEN
657: IF (l_mto_rules_rec.batch_creation_user <> l_user_id) THEN

Line 662: -- FND_GLOBAL.apps_initialize(l_mto_rules_rec.batch_creation_user,-1,-1);

658: IF (g_debug <= gme_debug.g_log_statement) THEN
659: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch creation user is '||l_mto_rules_rec.batch_creation_user);
660: END IF;
661: -- Bug 9355688 - Initialize with proper values not hard coded -1.
662: -- FND_GLOBAL.apps_initialize(l_mto_rules_rec.batch_creation_user,-1,-1);
663: FND_GLOBAL.apps_initialize(user_id => l_mto_rules_rec.batch_creation_user,
664: resp_id => l_resp_id,
665: resp_appl_id => l_resp_appl_id);
666: END IF;

Line 663: FND_GLOBAL.apps_initialize(user_id => l_mto_rules_rec.batch_creation_user,

659: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch creation user is '||l_mto_rules_rec.batch_creation_user);
660: END IF;
661: -- Bug 9355688 - Initialize with proper values not hard coded -1.
662: -- FND_GLOBAL.apps_initialize(l_mto_rules_rec.batch_creation_user,-1,-1);
663: FND_GLOBAL.apps_initialize(user_id => l_mto_rules_rec.batch_creation_user,
664: resp_id => l_resp_id,
665: resp_appl_id => l_resp_appl_id);
666: END IF;
667: END IF;

Line 675: gme_debug.put_line ('before create batch FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);

671: FND_FILE.Put_Line(FND_FILE.LOG, 'Batch/FPO qty needed is '||l_batch_qty);
672: IF (g_debug <= gme_debug.g_log_statement) THEN
673: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke Create_Batch API here');
674: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch qty required is '||l_batch_qty);
675: gme_debug.put_line ('before create batch FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);
676: gme_debug.put_line ('before create batch FND_GLOBAL.RESP_ID '||FND_GLOBAL.RESP_ID);
677: gme_debug.put_line ('before create batch FND_GLOBAL.RESP_APPL_ID '||FND_GLOBAL.RESP_APPL_ID);
678: END IF;
679: GME_API_PUB.create_batch(

Line 676: gme_debug.put_line ('before create batch FND_GLOBAL.RESP_ID '||FND_GLOBAL.RESP_ID);

672: IF (g_debug <= gme_debug.g_log_statement) THEN
673: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke Create_Batch API here');
674: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch qty required is '||l_batch_qty);
675: gme_debug.put_line ('before create batch FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);
676: gme_debug.put_line ('before create batch FND_GLOBAL.RESP_ID '||FND_GLOBAL.RESP_ID);
677: gme_debug.put_line ('before create batch FND_GLOBAL.RESP_APPL_ID '||FND_GLOBAL.RESP_APPL_ID);
678: END IF;
679: GME_API_PUB.create_batch(
680: p_api_version => 2.0,

Line 677: gme_debug.put_line ('before create batch FND_GLOBAL.RESP_APPL_ID '||FND_GLOBAL.RESP_APPL_ID);

673: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke Create_Batch API here');
674: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch qty required is '||l_batch_qty);
675: gme_debug.put_line ('before create batch FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);
676: gme_debug.put_line ('before create batch FND_GLOBAL.RESP_ID '||FND_GLOBAL.RESP_ID);
677: gme_debug.put_line ('before create batch FND_GLOBAL.RESP_APPL_ID '||FND_GLOBAL.RESP_APPL_ID);
678: END IF;
679: GME_API_PUB.create_batch(
680: p_api_version => 2.0,
681: p_validation_level => 100,

Line 906: --FND_GLOBAL.apps_initialize(l_user_id,-1,-1);

902: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for batch_id'||l_rsv_rec.supply_source_header_id);
903: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for batch_line_id'||l_rsv_rec.supply_source_line_id);
904: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for sales_line_id'||l_rsv_rec.demand_source_line_id);
905: END IF;
906: --FND_GLOBAL.apps_initialize(l_user_id,-1,-1);
907: GME_SUPPLY_RES_PVT.notify_CSR
908: ( P_Batch_id => l_rsv_rec.supply_source_header_id
909: , P_Batch_line_id => l_rsv_rec.supply_source_line_id
910: , P_So_line_id => l_rsv_rec.demand_source_line_id

Line 937: -- FND_GLOBAL.apps_initialize(l_user_id,-1,-1);

933:
934: /* Set the user context back to the original user */
935: IF (l_mto_rules_rec.batch_creation_user <> l_user_id) THEN
936: -- Bug 9355688 - Initialize with proper values not hard coded -1.
937: -- FND_GLOBAL.apps_initialize(l_user_id,-1,-1);
938: FND_GLOBAL.apps_initialize(user_id => l_user_id,
939: resp_id => l_resp_id,
940: resp_appl_id => l_resp_appl_id);
941: END IF;

Line 938: FND_GLOBAL.apps_initialize(user_id => l_user_id,

934: /* Set the user context back to the original user */
935: IF (l_mto_rules_rec.batch_creation_user <> l_user_id) THEN
936: -- Bug 9355688 - Initialize with proper values not hard coded -1.
937: -- FND_GLOBAL.apps_initialize(l_user_id,-1,-1);
938: FND_GLOBAL.apps_initialize(user_id => l_user_id,
939: resp_id => l_resp_id,
940: resp_appl_id => l_resp_appl_id);
941: END IF;
942: