666: oe_debug_pub.add('auto_create_pur_req_cr: entered ' ,1);
667: END IF;
668:
669: -- initialize the program_id and the request_id from the concurrent req
670: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
671: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
672:
673: /* bug fix 3590305/3599860 */
674: --
667: END IF;
668:
669: -- initialize the program_id and the request_id from the concurrent req
670: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
671: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
672:
673: /* bug fix 3590305/3599860 */
674: --
675: -- load all eligible lines into global temp table. We need to load the
714: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'l_source_code = '||lsourcecode,1);
715: END IF;
716:
717: -- set the batch_id to the request_id
718: l_batch_id := FND_GLOBAL.CONC_REQUEST_ID;
719:
720: -- Log all the input parameters
721: l_stmt_num := 1;
722:
1639:
1640: l_stmt_num := 10;
1641:
1642: -- Initialize all the standard variables.
1643: l_user_id := FND_GLOBAL.USER_ID;
1644: l_login_id := FND_GLOBAL.LOGIN_ID;
1645: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1646: l_application_id := FND_GLOBAL.RESP_APPL_ID;
1647: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1640: l_stmt_num := 10;
1641:
1642: -- Initialize all the standard variables.
1643: l_user_id := FND_GLOBAL.USER_ID;
1644: l_login_id := FND_GLOBAL.LOGIN_ID;
1645: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1646: l_application_id := FND_GLOBAL.RESP_APPL_ID;
1647: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1648: l_resp_id := FND_GLOBAL.RESP_ID;
1641:
1642: -- Initialize all the standard variables.
1643: l_user_id := FND_GLOBAL.USER_ID;
1644: l_login_id := FND_GLOBAL.LOGIN_ID;
1645: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1646: l_application_id := FND_GLOBAL.RESP_APPL_ID;
1647: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1648: l_resp_id := FND_GLOBAL.RESP_ID;
1649:
1642: -- Initialize all the standard variables.
1643: l_user_id := FND_GLOBAL.USER_ID;
1644: l_login_id := FND_GLOBAL.LOGIN_ID;
1645: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1646: l_application_id := FND_GLOBAL.RESP_APPL_ID;
1647: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1648: l_resp_id := FND_GLOBAL.RESP_ID;
1649:
1650: l_intf_source_code := p_interface_source_code;
1643: l_user_id := FND_GLOBAL.USER_ID;
1644: l_login_id := FND_GLOBAL.LOGIN_ID;
1645: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1646: l_application_id := FND_GLOBAL.RESP_APPL_ID;
1647: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1648: l_resp_id := FND_GLOBAL.RESP_ID;
1649:
1650: l_intf_source_code := p_interface_source_code;
1651:
1644: l_login_id := FND_GLOBAL.LOGIN_ID;
1645: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1646: l_application_id := FND_GLOBAL.RESP_APPL_ID;
1647: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1648: l_resp_id := FND_GLOBAL.RESP_ID;
1649:
1650: l_intf_source_code := p_interface_source_code;
1651:
1652: l_stmt_num := 20;
4569: end if;
4570:
4571:
4572: -- initialize the program_id and the request_id from the concurrent request.
4573: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
4574: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
4575:
4576: -- update th program_id and requist_id for the lines fetched by the cursor..
4577:
4570:
4571:
4572: -- initialize the program_id and the request_id from the concurrent request.
4573: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
4574: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
4575:
4576: -- update th program_id and requist_id for the lines fetched by the cursor..
4577:
4578: