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.INV_CONSUMPTION_ADVICE_PROC dependencies on FND_PROFILE

Line 68: g_user_id NUMBER := FND_PROFILE.value('USER_ID');

64: -- GLOBALS
65: --===================
66:
67: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_CONSUMPTION_ADVICE_PROC';
68: g_user_id NUMBER := FND_PROFILE.value('USER_ID');
69: g_resp_id NUMBER := FND_PROFILE.value('RESP_ID');
70: g_appl_id NUMBER;
71: -- Bug 5092489, commented becasue not used
72: --g_pgm_appl_id NUMBER;

Line 69: g_resp_id NUMBER := FND_PROFILE.value('RESP_ID');

65: --===================
66:
67: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_CONSUMPTION_ADVICE_PROC';
68: g_user_id NUMBER := FND_PROFILE.value('USER_ID');
69: g_resp_id NUMBER := FND_PROFILE.value('RESP_ID');
70: g_appl_id NUMBER;
71: -- Bug 5092489, commented becasue not used
72: --g_pgm_appl_id NUMBER;
73: g_log_level NUMBER := NULL;

Line 88: --g_org_id NUMBER := FND_PROFILE.value('ORG_ID');

84: g_batch_size NUMBER := 1000;
85: g_max_workers NUMBER := 1;
86: -- Bug 5092489, commented becasue not used
87: --g_unit_test_mode BOOLEAN := FALSE;
88: --g_org_id NUMBER := FND_PROFILE.value('ORG_ID');
89: g_submit_failure_exc EXCEPTION;
90: g_request_id NUMBER ;
91: --===================
92: -- PRIVATE PROCEDURES

Line 110: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

106: l_consumption_release_id NUMBER;
107: l_consumption_po_header_id NUMBER;
108: l_blanket_price NUMBER ;
109: l_interface_distribution_ref VARCHAR2(240);
110: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
111:
112: CURSOR txn_csr_type IS
113: SELECT
114: mct.transaction_id

Line 355: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

351: , p_global_rate IN NUMBER
352: , p_vendor_site_id IN NUMBER
353: )
354: IS
355: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
356: l_blanket_po_number VARCHAR2(20) := NULL;
357: l_error_explanation VARCHAR2(240) := NULL;
358: l_transaction_date DATE;
359:

Line 481: IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'

477: IF (l_consumption_processed_flag IS NULL) THEN
478: l_consumption_processed_flag := 'N';
479: END IF;
480:
481: IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'
482: THEN
483: -- Bug 5092489, Query modified to eliminate use of MMT in subquery
484: UPDATE MTL_CONSUMPTION_TRANSACTIONS mct
485: SET mct.consumption_po_header_id = p_consumption_po_header_id

Line 625: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

621: , p_inventory_item_id IN NUMBER
622: , p_organization_id IN NUMBER
623: )
624: IS
625: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
626: l_count NUMBER;
627: BEGIN
628:
629: IF (l_debug = 1)

Line 809: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

805: , p_inventory_item_id IN NUMBER
806: , p_organization_id IN NUMBER
807: )
808: IS
809: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
810: l_count NUMBER;
811: BEGIN
812:
813: IF (l_debug = 1)

Line 1230: NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1226: l_owning_organization_id NUMBER;
1227: l_org_id NUMBER;
1228: l_valid_flag VARCHAR2(1);
1229: l_debug NUMBER :=
1230: NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1231: l_error_msg VARCHAR2(100) := 'INV_SUP_CONS_NO_BPO_EXISTS';
1232: l_error_explanation VARCHAR2(240) := NULL;
1233: l_blanket_po_number VARCHAR2(20) := NULL;
1234:

Line 1476: NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1472: l_api_version NUMBER;
1473: -- Bug 5092489. Commented because not used.
1474: --l_precision NUMBER;
1475: l_debug NUMBER :=
1476: NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1477: l_vendor_name VARCHAR2(240);
1478: l_vendor_site VARCHAR2(15);
1479: l_transaction_date DATE;
1480: l_currency_code VARCHAR2(15);

Line 1586: l_user := FND_PROFILE.value('USER_ID');

1582: );
1583: END IF;
1584:
1585: x_return_status := FND_API.G_RET_STS_SUCCESS;
1586: l_user := FND_PROFILE.value('USER_ID');
1587: l_org_id := FND_PROFILE.value('ORG_ID');
1588: l_return_status := x_return_status;
1589:
1590: /* bug 5200436 - Start */

Line 1587: l_org_id := FND_PROFILE.value('ORG_ID');

1583: END IF;
1584:
1585: x_return_status := FND_API.G_RET_STS_SUCCESS;
1586: l_user := FND_PROFILE.value('USER_ID');
1587: l_org_id := FND_PROFILE.value('ORG_ID');
1588: l_return_status := x_return_status;
1589:
1590: /* bug 5200436 - Start */
1591: l_profile_option := NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N');

Line 1591: l_profile_option := NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N');

1587: l_org_id := FND_PROFILE.value('ORG_ID');
1588: l_return_status := x_return_status;
1589:
1590: /* bug 5200436 - Start */
1591: l_profile_option := NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N');
1592: /* bug 5200436 - End */
1593:
1594: l_curr_asl_index := l_asl_cons_tab.COUNT;
1595:

Line 2161: IF (nvl(fnd_profile.value('PO_AUTO_SOURCE_DOC'),'N') = 'Y') THEN

2157: Supplier List. There is no check for the presence of a record in the table po_asl_documents if
2158: the Profile Option PO: Automatic Document Sourcing is set to "No". The blanket is picked up
2159: from MMT.TRANSACTION_SOURCE_ID when the profile is set to "No" */
2160:
2161: IF (nvl(fnd_profile.value('PO_AUTO_SOURCE_DOC'),'N') = 'Y') THEN
2162:
2163: INSERT INTO po_lines_interface
2164: ( interface_header_id
2165: , interface_line_id

Line 2777: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2773: , p_batch_id IN NUMBER
2774: , p_tax_rec_rate_tab IN g_cons_tbl_type -- Bug 4969421
2775: )
2776: IS
2777: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2778: -- Bug 5092489, commenting as not used
2779: --l_txn_count NUMBER;
2780: --l_txn_first NUMBER;
2781: --l_txn_last NUMBER;

Line 2952: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2948: , p_batch_id IN NUMBER
2949: , p_tax_rec_rate_tab IN g_cons_tbl_type -- Bug 4969421
2950: )
2951: IS
2952: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2953: -- Bug 5092489, commenting as not used
2954: --l_txn_count NUMBER;
2955: --l_txn_first NUMBER;
2956: --l_txn_last NUMBER;

Line 3165: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3161: , p_rate IN NUMBER
3162: , p_rate_type IN VARCHAR
3163: )
3164: IS
3165: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3166: BEGIN
3167:
3168: IF (l_debug = 1)
3169: THEN

Line 3246: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3242: -- the top level procedure of each concurrent program
3243: --========================================================================
3244: PROCEDURE Log_Initialize
3245: IS
3246: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3247: BEGIN
3248:
3249: IF (l_debug = 1)
3250: THEN

Line 3257: g_log_level := TO_NUMBER(FND_PROFILE.Value('AFLOG_LEVEL'));

3253: , 9
3254: );
3255: END IF;
3256:
3257: g_log_level := TO_NUMBER(FND_PROFILE.Value('AFLOG_LEVEL'));
3258: IF g_log_level IS NULL THEN
3259: g_log_mode := 'OFF';
3260: ELSE
3261: IF (TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID')) <> 0) THEN

Line 3261: IF (TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID')) <> 0) THEN

3257: g_log_level := TO_NUMBER(FND_PROFILE.Value('AFLOG_LEVEL'));
3258: IF g_log_level IS NULL THEN
3259: g_log_mode := 'OFF';
3260: ELSE
3261: IF (TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID')) <> 0) THEN
3262: g_log_mode := 'SRS';
3263: ELSE
3264: g_log_mode := 'SQL';
3265: END IF;

Line 3291: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3287: ( p_priority IN NUMBER
3288: , p_msg IN VARCHAR2
3289: )
3290: IS
3291: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3292: BEGIN
3293:
3294: IF (l_debug = 1)
3295: THEN

Line 3363: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3359: --=================
3360:
3361: l_error_code VARCHAR2(10);
3362: l_txn_id NUMBER;
3363: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3364:
3365:
3366: BEGIN
3367:

Line 3498: NVL(FND_PROFILE.VALUE

3494: l_organization_id NUMBER := 0;
3495: l_current_txn_source_id NUMBER := 0;
3496: l_inventory_item_id NUMBER := 0;
3497: l_debug NUMBER :=
3498: NVL(FND_PROFILE.VALUE
3499: ('INV_DEBUG_TRACE'),0);
3500:
3501:
3502: BEGIN

Line 3516: IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'

3512: -- Call procedure to load MTL_CONSUMPTION_TXNS_TEMP
3513: -- from MTL_CONSUMPTION_TRANSACTIONS
3514: -- with records that belong to the specified batch
3515:
3516: IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'
3517: THEN
3518: INV_CONSUMPTION_ADVICE_PROC.load_combination_prf
3519: (p_batch_id => p_batch_id
3520: ,p_vendor_id => NULL

Line 3595: IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'

3591: -- records in MTL_CONSUMPTION_TXNS_TEMP.
3592: -- Record the result in MTL_CONSUMPTION_TXNS_TEMP.
3593:
3594: /* BUg 5092489. Following IF block is commented becasue quantity is populated during insert
3595: IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'
3596: THEN
3597: INV_CONSUMPTION_ADVICE_PROC.load_summarized_quantity_prf
3598: (p_txn_source_tab => l_txn_source_tab
3599: ,p_inventory_item_tab => l_item_tab

Line 3856: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3852: FUNCTION generate_batch_id
3853: RETURN NUMBER
3854: IS
3855: l_batch_id NUMBER;
3856: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3857: BEGIN
3858:
3859: IF (l_debug = 1)
3860: THEN

Line 3899: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3895: RETURN BOOLEAN
3896: IS
3897: l_count NUMBER;
3898: l_result BOOLEAN;
3899: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3900: BEGIN
3901:
3902: IF (l_debug = 1)
3903: THEN

Line 3949: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3945: , x_worker_idx OUT NOCOPY BINARY_INTEGER
3946: )
3947: IS
3948: l_done BOOLEAN;
3949: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3950: BEGIN
3951:
3952: IF (l_debug = 1)
3953: THEN

Line 4003: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3999: ( p_workers IN g_request_tbl_type
4000: )
4001: IS
4002: l_done BOOLEAN;
4003: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4004: BEGIN
4005:
4006: IF (l_debug = 1)
4007: THEN

Line 4069: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4065: IS
4066: l_worker_idx BINARY_INTEGER;
4067: l_request_id NUMBER;
4068: l_org_name VARCHAR2(60) := NULL;
4069: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4070: BEGIN
4071:
4072: IF (l_debug = 1)
4073: THEN

Line 4196: l_debug NUMBER := NVL(FND_PROFILE.VALUE

4192: l_count NUMBER;
4193: l_max_workers NUMBER;
4194: l_org_id NUMBER;
4195: l_new_batch VARCHAR2(1) := 'Y';
4196: l_debug NUMBER := NVL(FND_PROFILE.VALUE
4197: ('INV_DEBUG_TRACE'),0);
4198: l_debug_txn_id NUMBER;
4199:
4200:

Line 4437: --IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'

4433: OR (l_group_size > l_remain_batch_count AND l_new_batch = 'N')
4434: OR l_current_cons_index = l_txn_source_tab.LAST
4435: THEN
4436:
4437: --IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'
4438: --THEN
4439: FORALL i IN l_previous_cons_index..l_current_cons_index
4440: --Bug 5092489, Query modified to eliminate use of MMT
4441: UPDATE

Line 4722: l_debug NUMBER := NVL(FND_PROFILE.VALUE

4718: l_blanket_query VARCHAR2(15000); -- Bug 4666585
4719: */
4720: l_count NUMBER;
4721: l_batch_id NUMBER := -1;
4722: l_debug NUMBER := NVL(FND_PROFILE.VALUE
4723: ('INV_DEBUG_TRACE'),0);
4724:
4725:
4726:

Line 4763: TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID') ) ;

4759: END IF;
4760:
4761: g_request_id := NULL;
4762: g_request_id :=
4763: TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID') ) ;
4764:
4765: IF (l_debug = 1)
4766: THEN
4767: INV_LOG_UTIL.trace

Line 5283: IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'

5279: , 9
5280: );
5281: END IF;
5282: */
5283: IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'
5284: THEN
5285: INV_CONSUMPTION_ADVICE_PROC.load_combination_prf
5286: (p_batch_id => l_batch_id
5287: ,p_vendor_id => p_vendor_id