DBA Data[Home] [Help]

APPS.GR_PROCESS_ORDERS dependencies on GR_PROCESS_DOCUMENTS

Line 909: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

905: SELECT gr_work_build_docs_s.nextval INTO g_session_id
906: FROM dual;
907:
908: l_return_status := 'S';
909: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
910: ('F',
911: g_session_id,
912: l_return_status,
913: l_oracle_error,

Line 2525: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

2521: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
2522: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2523:
2524: l_return_status := 'S';
2525: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
2526: ('F',
2527: g_session_id,
2528: l_return_status,
2529: l_oracle_error,

Line 2590: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

2586: IF c_get_cust_address%FOUND THEN
2587:
2588: /* Fix for B1270176 */
2589: l_return_status := 'S';
2590: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
2591: ('F',
2592: g_session_id,
2593: l_return_status,
2594: l_oracle_error,

Line 2638: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

2634: END IF;
2635:
2636: /* Fix for B1270176 */
2637: l_return_status := 'S';
2638: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
2639: ('F',
2640: g_session_id,
2641: l_return_status,
2642: l_oracle_error,

Line 2693: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

2689: WHILE c_get_master_list%FOUND LOOP
2690: g_doc_item_code := LocalInventList.item_no;
2691: /* Fix for B1270176 */
2692: l_return_status := 'S';
2693: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
2694: ('F',
2695: g_session_id,
2696: l_return_status,
2697: l_oracle_error,

Line 2758: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

2754: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2755:
2756: /* Fix for B1270176 */
2757: l_return_status := 'S';
2758: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
2759: ('F',
2760: g_session_id,
2761: l_return_status,
2762: l_oracle_error,

Line 2803: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

2799: END IF;
2800:
2801: /* Fix for B1270176*/
2802: l_return_status := 'S';
2803: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
2804: ('F',
2805: g_session_id,
2806: l_return_status,
2807: l_oracle_error,

Line 2858: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

2854: WHILE c_get_master_list%FOUND LOOP
2855: g_doc_item_code := LocalInventList.item_no;
2856: /* Fix for B1270176 */
2857: l_return_status := 'S';
2858: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
2859: ('F',
2860: g_session_id,
2861: l_return_status,
2862: l_oracle_error,

Line 2932: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

2928: IF c_get_cust_address%FOUND THEN
2929:
2930: /* Fix for B1270176 */
2931: l_return_status := 'S';
2932: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
2933: ('F',
2934: g_session_id,
2935: l_return_status,
2936: l_oracle_error,

Line 2978: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

2974: END IF;
2975:
2976: /* Fix for B1270176 */
2977: l_return_status := 'S';
2978: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
2979: ('F',
2980: g_session_id,
2981: l_return_status,
2982: l_oracle_error,

Line 3032: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

3028: WHILE c_get_master_list%FOUND LOOP
3029: g_doc_item_code := LocalInventList.item_no;
3030: /* Fix for B1270176 */
3031: l_return_status := 'S';
3032: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
3033: ('F',
3034: g_session_id,
3035: l_return_status,
3036: l_oracle_error,

Line 3093: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

3089: WHILE g_get_other_addresses%FOUND LOOP
3090:
3091: /* Fix for B1270176 */
3092: l_return_status := 'S';
3093: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
3094: ('F',
3095: g_session_id,
3096: l_return_status,
3097: l_oracle_error,

Line 3139: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

3135: END IF;
3136:
3137: /* Fix for B1270176 */
3138: l_return_status := 'S';
3139: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
3140: ('F',
3141: g_session_id,
3142: l_return_status,
3143: l_oracle_error,

Line 3194: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

3190: WHILE c_get_master_list%FOUND LOOP
3191: g_doc_item_code := LocalInventList.item_no;
3192: /* Fix for B1270176 */
3193: l_return_status := 'S';
3194: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
3195: ('F',
3196: g_session_id,
3197: l_return_status,
3198: l_oracle_error,

Line 3290: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

3286: IF c_get_cust_address%FOUND THEN
3287:
3288: /* Fix for B1270176 */
3289: l_return_status := 'S';
3290: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
3291: ('F',
3292: g_session_id,
3293: l_return_status,
3294: l_oracle_error,

Line 3336: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

3332: END IF;
3333:
3334: /* Fix for B1270176 */
3335: l_return_status := 'S';
3336: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
3337: ('F',
3338: g_session_id,
3339: l_return_status,
3340: l_oracle_error,

Line 3394: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

3390: WHILE g_get_other_addresses%FOUND LOOP
3391:
3392: /* Fix for B1270176 */
3393: l_return_status := 'S';
3394: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
3395: ('F',
3396: g_session_id,
3397: l_return_status,
3398: l_oracle_error,

Line 3440: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

3436: END IF;
3437:
3438: /* Fix for B1270176 */
3439: l_return_status := 'S';
3440: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
3441: ('F',
3442: g_session_id,
3443: l_return_status,
3444: l_oracle_error,

Line 3503: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

3499: IF c_get_cust_address%FOUND THEN
3500:
3501: /* Fix for B1270176 */
3502: l_return_status := 'S';
3503: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
3504: ('F',
3505: g_session_id,
3506: l_return_status,
3507: l_oracle_error,

Line 3549: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

3545: END IF;
3546:
3547: /* Fix for B1270176 */
3548: l_return_status := 'S';
3549: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
3550: ('F',
3551: g_session_id,
3552: l_return_status,
3553: l_oracle_error,

Line 3604: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

3600: WHILE g_get_other_addresses%FOUND LOOP
3601:
3602: /* Fix for B1270176 */
3603: l_return_status := 'S';
3604: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
3605: ('F',
3606: g_session_id,
3607: l_return_status,
3608: l_oracle_error,

Line 3650: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

3646: END IF;
3647:
3648: /* Fix for B1270176 */
3649: l_return_status := 'S';
3650: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
3651: ('F',
3652: g_session_id,
3653: l_return_status,
3654: l_oracle_error,

Line 4541: GR_PROCESS_DOCUMENTS.Build_Item_Document

4537: */
4538: FND_FILE.PUT(FND_FILE.LOG, 'Processing Build_Item_Document for: ' || p_item_code || ' ' || TO_CHAR(g_session_id));
4539: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4540:
4541: GR_PROCESS_DOCUMENTS.Build_Item_Document
4542: (l_commit,
4543: l_init_msg_list,
4544: l_validation_level,
4545: l_api_version,