DBA Data[Home] [Help]

APPS.INV_UI_PROJECT_LOVS dependencies on FND_PROFILE

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

4: p_err_msg VARCHAR2,
5: p_level NUMBER DEFAULT 4
6: )
7: IS
8: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
9: BEGIN
10: IF ( l_debug = 1 ) THEN
11: inv_mobile_helper_functions.tracelog ( p_err_msg => p_err_msg,
12: p_module => 'inv_PROJECT_LOVS',

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

24: p_item_id IN NUMBER DEFAULT NULL,
25: p_po_release_id IN NUMBER DEFAULT NULL--BUG 4201013
26: )
27: IS
28: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
29: l_no_proj_str VARCHAR2(2000);--BUG 4599723
30: BEGIN
31: l_no_proj_str := FND_MESSAGE.GET_STRING ( 'INV', 'INV_NO_PROJECT' );
32: IF (l_debug = 1) THEN

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

107: p_item_id IN NUMBER DEFAULT NULL,
108: p_po_release_id IN NUMBER DEFAULT NULL--BUG 4201013
109: )
110: IS
111: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
112: l_no_proj_str VARCHAR2(2000);--BUG 4599723
113: BEGIN
114:
115: l_no_proj_str := FND_MESSAGE.GET_STRING ( 'INV', 'INV_NO_PROJECT' );

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

221: p_po_header_id IN NUMBER,
222: p_lpn_id IN NUMBER DEFAULT NULL
223: )
224: IS
225: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
226: l_no_proj_str VARCHAR2(2000);
227: BEGIN
228: l_no_proj_str := FND_MESSAGE.GET_STRING ( 'INV', 'INV_NO_PROJECT' );
229: IF (l_debug = 1) THEN

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

328: p_item_id IN NUMBER DEFAULT NULL,
329: p_lpn_id IN NUMBER DEFAULT NULL
330: )
331: IS
332: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
333: l_no_proj_str VARCHAR2(2000);
334: BEGIN
335: print_debug ( 'Receiving for req projects : for req ' || p_req_header_id
336: );

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

437: p_project_number IN VARCHAR2,
438: p_item_id IN NUMBER DEFAULT NULL
439: )
440: IS
441: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
442: l_no_proj_str VARCHAR2(2000);
443: BEGIN
444: l_no_proj_str := FND_MESSAGE.GET_STRING ( 'INV', 'INV_NO_PROJECT' );
445: IF (l_debug = 1) THEN

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

493: x_projects OUT NOCOPY /* file.sql.39 change */ t_genref,
494: p_restrict_projects IN VARCHAR
495: )
496: IS
497: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
498: BEGIN
499: OPEN x_projects FOR
500: SELECT p.project_id,
501: NVL ( p.project_number, ' ' ),

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

519: p_po_release_id IN NUMBER DEFAULT NULL, --BUG 4201013
520: p_is_deliver IN VARCHAR2 DEFAULT 'F' --Bug 6785303
521: )
522: IS
523: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
524: BEGIN
525: /* Bug 6785303 if p_is_deliver then call GET_RCV_PO_DELIVER_PROJECTS */
526: IF DOCUMENT_TYPE = 'PO' THEN
527: IF p_is_deliver = 'T' THEN

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

584: p_unscheduled_flag IN NUMBER,
585: p_project_number IN VARCHAR2
586: )
587: IS
588: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
589: BEGIN
590:
591: -- bug 4662395 set the profile mfg_organization_id so
592: -- the call to PJM_PROJECTS_MTLL_V will return data.

Line 594: FND_PROFILE.put('MFG_ORGANIZATION_ID',p_organization_id);

590:
591: -- bug 4662395 set the profile mfg_organization_id so
592: -- the call to PJM_PROJECTS_MTLL_V will return data.
593:
594: FND_PROFILE.put('MFG_ORGANIZATION_ID',p_organization_id);
595:
596: IF p_unscheduled_flag = 2 THEN
597: IF ( l_debug = 1 ) THEN
598: inv_log_util.TRACE ( 'Unsceduled flag = 2 '

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

643: p_physical_inventory_id IN NUMBER,
644: p_project_number IN VARCHAR2
645: )
646: IS
647: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
648: BEGIN
649:
650: -- bug 4662395 set the profile mfg_organization_id so
651: -- the call to PJM_PROJECTS_MTLL_V will return data.

Line 653: FND_PROFILE.put('MFG_ORGANIZATION_ID',p_organization_id);

649:
650: -- bug 4662395 set the profile mfg_organization_id so
651: -- the call to PJM_PROJECTS_MTLL_V will return data.
652:
653: FND_PROFILE.put('MFG_ORGANIZATION_ID',p_organization_id);
654:
655: IF ( p_dynamic_entry_flag = 2 ) THEN
656: OPEN x_projects FOR
657: SELECT DISTINCT p.project_id,

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

684: p_organization_id IN NUMBER,
685: p_mo_header_id IN NUMBER
686: )
687: IS
688: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
689: BEGIN
690:
691: -- bug 4662395 set the profile mfg_organization_id so
692: -- the call to PJM_PROJECTS_MTLL_V will return data.

Line 694: FND_PROFILE.put('MFG_ORGANIZATION_ID',p_organization_id);

690:
691: -- bug 4662395 set the profile mfg_organization_id so
692: -- the call to PJM_PROJECTS_MTLL_V will return data.
693:
694: FND_PROFILE.put('MFG_ORGANIZATION_ID',p_organization_id);
695:
696: OPEN x_projects FOR
697: SELECT p.project_id,
698: NVL ( p.project_number, ' ' ),