DBA Data[Home] [Help]

APPS.WSM_WIP_LOT_TXN_PVT dependencies on WSMPJUPD

Line 1246: --incorrect check on l_request_id in WSMPJUPD.This has been fixed and

1242: p_run_log_level => l_log_level
1243: );
1244: End if;
1245: --Bug 5263262:Req import was not invoked because of
1246: --incorrect check on l_request_id in WSMPJUPD.This has been fixed and
1247: --hence the following fix is not needed.
1248: -- Invoke the Req Processor if needed (for forms and MES)
1249: -- ST : Fix for bug 5263262 : Invoke the worker for MES, forms..
1250: -- For interface it will be done in a single shot in WSMPLOAD

Line 1251: --IF nvl(p_invoke_req_worker,1) = 1 AND WSMPJUPD.g_osp_exists = 1 THEN

1247: --hence the following fix is not needed.
1248: -- Invoke the Req Processor if needed (for forms and MES)
1249: -- ST : Fix for bug 5263262 : Invoke the worker for MES, forms..
1250: -- For interface it will be done in a single shot in WSMPLOAD
1251: --IF nvl(p_invoke_req_worker,1) = 1 AND WSMPJUPD.g_osp_exists = 1 THEN
1252: -- l_poreq_request_id := fnd_request.submit_request('PO', 'REQIMPORT', NULL, NULL, FALSE,'WIP', NULL, 'ITEM',
1253: -- NULL ,'N', 'Y' , chr(0), NULL, NULL, NULL,
1254: -- NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1255: -- NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 1665: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,

1661: /* Log the Procedure entry point.... */
1662: if( g_log_level_statement >= l_log_level ) then
1663: l_msg_tokens.delete;
1664: WSM_log_PVT.logMessage(p_module_name => l_module ,
1665: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,
1666: p_stmt_num => l_stmt_num ,
1667: p_msg_tokens => l_msg_tokens,
1668: p_fnd_log_level => g_log_level_statement,
1669: p_run_log_level => l_log_level

Line 1676: WSMPJUPD.PROCESS_LOTS (p_copy_qa => null,

1672:
1673: l_wltx_starting_jobs_tbl(1) := (p_wltx_starting_job_rec);
1674:
1675: /* call Process lots now....*/
1676: WSMPJUPD.PROCESS_LOTS (p_copy_qa => null,
1677: p_txn_org_id => p_wltx_header.organization_id,
1678: p_rep_job_index => l_wltx_starting_jobs_tbl.first,
1679: p_wltx_header => p_wltx_header,
1680: p_wltx_starting_jobs_tbl => l_wltx_starting_jobs_tbl,

Line 1692: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',

1688: /* Log the Procedure exit point.... */
1689: if( g_log_level_statement >= l_log_level ) then
1690: l_msg_tokens.delete;
1691: WSM_log_PVT.logMessage(p_module_name => l_module ,
1692: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',
1693: p_stmt_num => l_stmt_num ,
1694: p_msg_tokens => l_msg_tokens,
1695: p_fnd_log_level => g_log_level_statement,
1696: p_run_log_level => l_log_level

Line 2156: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,

2152: /* Log the Procedure entry point....proc entry */
2153: if( g_log_level_statement >= l_log_level ) then
2154: l_msg_tokens.delete;
2155: WSM_log_PVT.logMessage(p_module_name => l_module ,
2156: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,
2157: p_stmt_num => l_stmt_num,
2158: p_msg_tokens => l_msg_tokens,
2159: p_fnd_log_level => g_log_level_statement,
2160: p_run_log_level => l_log_level

Line 2166: WSMPJUPD.PROCESS_LOTS (p_copy_qa => null,

2162: End if;
2163:
2164: /* call Process lots now....*/
2165: l_wltx_resulting_jobs_tbl(1) := p_wltx_resulting_job_rec;
2166: WSMPJUPD.PROCESS_LOTS (p_copy_qa => null,
2167: p_txn_org_id => p_wltx_header.organization_id,
2168: p_rep_job_index => l_rep_job_index,
2169: p_wltx_header => p_wltx_header,
2170: p_wltx_starting_jobs_tbl => p_wltx_starting_jobs_tbl,

Line 2182: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',

2178: /* Log the Procedure exit point....proc exit */
2179: if( g_log_level_statement >= l_log_level ) then
2180: l_msg_tokens.delete;
2181: WSM_log_PVT.logMessage(p_module_name => l_module ,
2182: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',
2183: p_stmt_num => l_stmt_num ,
2184: p_msg_tokens => l_msg_tokens,
2185: p_fnd_log_level => g_log_level_statement,
2186: p_run_log_level => l_log_level

Line 2628: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,

2624: /* Log the Procedure entry point.... */
2625: if( g_log_level_statement >= l_log_level ) then
2626: l_msg_tokens.delete;
2627: WSM_log_PVT.logMessage(p_module_name => l_module ,
2628: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,
2629: p_stmt_num => l_stmt_num ,
2630: p_msg_tokens => l_msg_tokens,
2631: p_fnd_log_level => g_log_level_statement,
2632: p_run_log_level => l_log_level

Line 2640: WSMPJUPD.PROCESS_LOTS( p_copy_qa => null,

2636: /* call Process lots now....*/
2637: l_wltx_starting_jobs_tbl(1) := p_wltx_starting_job_rec;
2638: l_wltx_resulting_jobs_tbl(1) := p_wltx_resulting_job_rec;
2639:
2640: WSMPJUPD.PROCESS_LOTS( p_copy_qa => null,
2641: p_txn_org_id => p_wltx_header.organization_id,
2642: p_rep_job_index => l_wltx_starting_jobs_tbl.first,
2643: p_wltx_header => p_wltx_header,
2644: p_wltx_starting_jobs_tbl => l_wltx_starting_jobs_tbl,

Line 2656: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',

2652: /* Log the Procedure exit point.... */
2653: if( g_log_level_statement >= l_log_level ) then
2654: l_msg_tokens.delete;
2655: WSM_log_PVT.logMessage(p_module_name => l_module ,
2656: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',
2657: p_stmt_num => l_stmt_num ,
2658: p_msg_tokens => l_msg_tokens,
2659: p_fnd_log_level => g_log_level_statement,
2660: p_run_log_level => l_log_level

Line 3107: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,

3103: /* Log the Procedure entry point.... */
3104: if( g_log_level_statement >= l_log_level ) then
3105: l_msg_tokens.delete;
3106: WSM_log_PVT.logMessage(p_module_name => l_module ,
3107: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,
3108: p_stmt_num => l_stmt_num ,
3109: p_msg_tokens => l_msg_tokens,
3110: p_fnd_log_level => g_log_level_statement,
3111: p_run_log_level => l_log_level

Line 3119: WSMPJUPD.PROCESS_LOTS( p_copy_qa => null,

3115: /* call Process lots now....*/
3116: l_wltx_starting_jobs_tbl(1) := p_wltx_starting_job_rec;
3117: l_wltx_resulting_jobs_tbl(1) := p_wltx_resulting_job_rec;
3118:
3119: WSMPJUPD.PROCESS_LOTS( p_copy_qa => null,
3120: p_txn_org_id => p_wltx_header.organization_id,
3121: p_rep_job_index => l_wltx_starting_jobs_tbl.first,
3122: p_wltx_header => p_wltx_header,
3123: p_wltx_starting_jobs_tbl => l_wltx_starting_jobs_tbl,

Line 3135: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',

3131: /* Log the Procedure exit point.... */
3132: if( g_log_level_statement >= l_log_level ) then
3133: l_msg_tokens.delete;
3134: WSM_log_PVT.logMessage(p_module_name => l_module ,
3135: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',
3136: p_stmt_num => l_stmt_num ,
3137: p_msg_tokens => l_msg_tokens,
3138: p_fnd_log_level => g_log_level_statement,
3139: p_run_log_level => l_log_level

Line 3582: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,

3578: /* Log the Procedure entry point.... */
3579: if( g_log_level_statement >= l_log_level ) then
3580: l_msg_tokens.delete;
3581: WSM_log_PVT.logMessage(p_module_name => l_module ,
3582: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,
3583: p_stmt_num => l_stmt_num ,
3584: p_msg_tokens => l_msg_tokens,
3585: p_fnd_log_level => g_log_level_statement,
3586: p_run_log_level => l_log_level

Line 3594: WSMPJUPD.PROCESS_LOTS ( p_copy_qa => null,

3590: /* call Process lots now....*/
3591: l_wltx_starting_jobs_tbl(1) := p_wltx_starting_job_rec;
3592: l_wltx_resulting_jobs_tbl(1) := p_wltx_resulting_job_rec;
3593:
3594: WSMPJUPD.PROCESS_LOTS ( p_copy_qa => null,
3595: p_txn_org_id => p_wltx_header.organization_id,
3596: p_rep_job_index => l_wltx_starting_jobs_tbl.first,
3597: p_wltx_header => p_wltx_header,
3598: p_wltx_starting_jobs_tbl => l_wltx_starting_jobs_tbl,

Line 3610: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',

3606: /* Log the Procedure exit point.... */
3607: if( g_log_level_statement >= l_log_level ) then
3608: l_msg_tokens.delete;
3609: WSM_log_PVT.logMessage(p_module_name => l_module ,
3610: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',
3611: p_stmt_num => l_stmt_num ,
3612: p_msg_tokens => l_msg_tokens,
3613: p_fnd_log_level => g_log_level_statement,
3614: p_run_log_level => l_log_level

Line 4053: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,

4049: /* Log the Procedure entry point.... */
4050: if( g_log_level_statement >= l_log_level ) then
4051: l_msg_tokens.delete;
4052: WSM_log_PVT.logMessage(p_module_name => l_module ,
4053: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,
4054: p_stmt_num => l_stmt_num ,
4055: p_msg_tokens => l_msg_tokens,
4056: p_fnd_log_level => g_log_level_statement,
4057: p_run_log_level => l_log_level

Line 4065: WSMPJUPD.PROCESS_LOTS ( p_copy_qa => null,

4061: /* call Process lots now....*/
4062: l_wltx_starting_jobs_tbl(1) := p_wltx_starting_job_rec;
4063: l_wltx_resulting_jobs_tbl(1) := p_wltx_resulting_job_rec;
4064:
4065: WSMPJUPD.PROCESS_LOTS ( p_copy_qa => null,
4066: p_txn_org_id => p_wltx_header.organization_id,
4067: p_rep_job_index => l_wltx_starting_jobs_tbl.first,
4068: p_wltx_header => p_wltx_header,
4069: p_wltx_starting_jobs_tbl => l_wltx_starting_jobs_tbl,

Line 4081: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',

4077: /* Log the Procedure exit point.... */
4078: if( g_log_level_statement >= l_log_level ) then
4079: l_msg_tokens.delete;
4080: WSM_log_PVT.logMessage(p_module_name => l_module ,
4081: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',
4082: p_stmt_num => l_stmt_num ,
4083: p_msg_tokens => l_msg_tokens,
4084: p_fnd_log_level => g_log_level_statement,
4085: p_run_log_level => l_log_level

Line 4439: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,

4435: /* Log the Procedure entry point.... */
4436: if( g_log_level_statement >= l_log_level ) then
4437: l_msg_tokens.delete;
4438: WSM_log_PVT.logMessage(p_module_name => l_module ,
4439: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,
4440: p_stmt_num => l_stmt_num,
4441: p_msg_tokens => l_msg_tokens,
4442: p_fnd_log_level => g_log_level_statement,
4443: p_run_log_level => l_log_level

Line 4450: WSMPJUPD.PROCESS_LOTS ( p_copy_qa => null,

4446:
4447: /* call Process lots now....*/
4448: l_wltx_resulting_jobs_tbl(1) := p_wltx_resulting_job_rec;
4449:
4450: WSMPJUPD.PROCESS_LOTS ( p_copy_qa => null,
4451: p_txn_org_id => p_wltx_header.organization_id,
4452: p_rep_job_index => l_wltx_starting_jobs_tbl.first,
4453: p_wltx_header => p_wltx_header,
4454: p_wltx_starting_jobs_tbl => l_wltx_starting_jobs_tbl,

Line 4466: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',

4462: /* Log the Procedure exit point.... */
4463: if( g_log_level_statement >= l_log_level ) then
4464: l_msg_tokens.delete;
4465: WSM_log_PVT.logMessage(p_module_name => l_module ,
4466: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',
4467: p_stmt_num => l_stmt_num ,
4468: p_msg_tokens => l_msg_tokens,
4469: p_fnd_log_level => g_log_level_statement,
4470: p_run_log_level => l_log_level