APPS.WSM_WLT_VALIDATE_PVT dependencies on WIP_REVISIONS

Line 5756: -- This is done b'cos the call to wip_revisions.*** procedures throw an app_exception

5752: l_error_out NUMBER := 0; -- ST : Added for bug 5218479 --
5753: e_invalid_revision exception; -- ST : Added for bug 5218479 --
5754:
5755: -- ST : Added for bug 5218479
5756: -- This is done b'cos the call to wip_revisions.*** procedures throw an app_exception
5757: -- app_exception is nothing but raise_application_error(-20001,
5758: -- So this has to be handled as a function error and not as an unexpected error...
5759: PRAGMA EXCEPTION_INIT(e_invalid_revision,-20001);
5760:

Line 5951: -- call wip_revisions

5947:
5948: -- ST : Fix for bug 5218479 : Added the BEGIN clause --
5949: l_error_out := 0;
5950: BEGIN
5951: -- call wip_revisions
5952: wip_revisions.routing_revision(p_organization_id => p_txn_org_id,
5953: p_item_id => l_item_id,
5954: p_revision => p_rj_rtg_revision,
5955: p_revision_date => p_rj_rtg_revision_date,

Line 5952: wip_revisions.routing_revision(p_organization_id => p_txn_org_id,

5948: -- ST : Fix for bug 5218479 : Added the BEGIN clause --
5949: l_error_out := 0;
5950: BEGIN
5951: -- call wip_revisions
5952: wip_revisions.routing_revision(p_organization_id => p_txn_org_id,
5953: p_item_id => l_item_id,
5954: p_revision => p_rj_rtg_revision,
5955: p_revision_date => p_rj_rtg_revision_date,
5956: p_start_date => p_rj_rtg_revision_date

Line 5962: p_msg_text => 'return from wip_revisions.routing_revision',

5958:
5959: IF( g_log_level_statement >= l_log_level ) THEN
5960: l_msg_tokens.delete;
5961: WSM_log_PVT.logMessage(p_module_name => l_module ,
5962: p_msg_text => 'return from wip_revisions.routing_revision',
5963: p_stmt_num => l_stmt_num ,
5964: p_msg_tokens => l_msg_tokens,
5965: p_fnd_log_level => g_log_level_statement,
5966: p_run_log_level => l_log_level

Line 5988: wip_revisions.routing_revision( p_organization_id => p_txn_org_id,

5984: l_error_out := 0;
5985: l_stmt_num := 30;
5986: BEGIN
5987:
5988: wip_revisions.routing_revision( p_organization_id => p_txn_org_id,
5989: p_item_id => l_item_id,
5990: p_revision => l_rtg_revision,
5991: p_revision_date => p_rj_rtg_revision_date,
5992: p_start_date => p_rj_rtg_revision_date

Line 6134: -- This is done b'cos the call to wip_revisions.*** procedures throw an app_exception

6130: l_error_out NUMBER := 0; -- ST : Added for bug 5218479 --
6131: e_invalid_revision exception; -- ST : Added for bug 5218479 --
6132:
6133: -- ST : Added for bug 5218479
6134: -- This is done b'cos the call to wip_revisions.*** procedures throw an app_exception
6135: -- app_exception is nothing but raise_application_error(-20001,
6136: -- So this has to be handled as a function error and not as an unexpected error...
6137: PRAGMA EXCEPTION_INIT(e_invalid_revision,-20001);
6138:

Line 6299: -- call wip_revisions

6295: end if;
6296:
6297: -- ST : Fix for bug 5218479 start : Added the BEGIN clause --
6298: BEGIN
6299: -- call wip_revisions
6300: wip_revisions.bom_revision( p_organization_id => p_txn_org_id,
6301: p_item_id => l_item_id,
6302: p_revision => p_rj_bom_revision,
6303: p_revision_date => p_rj_bom_revision_date,

Line 6300: wip_revisions.bom_revision( p_organization_id => p_txn_org_id,

6296:
6297: -- ST : Fix for bug 5218479 start : Added the BEGIN clause --
6298: BEGIN
6299: -- call wip_revisions
6300: wip_revisions.bom_revision( p_organization_id => p_txn_org_id,
6301: p_item_id => l_item_id,
6302: p_revision => p_rj_bom_revision,
6303: p_revision_date => p_rj_bom_revision_date,
6304: p_start_date => p_rj_bom_revision_date

Line 6323: wip_revisions.bom_revision( p_organization_id => p_txn_org_id,

6319: end if;
6320:
6321: -- ST : Fix for bug 5218479 : Added BEGIN clause --
6322: BEGIN
6323: wip_revisions.bom_revision( p_organization_id => p_txn_org_id,
6324: p_item_id => l_item_id,
6325: p_revision => l_bom_revision,
6326: p_revision_date => p_rj_bom_revision_date,
6327: p_start_date => p_rj_bom_revision_date