DBA Data[Home] [Help]

APPS.WSMPJUPD dependencies on INV_GENEALOGY_PUB

Line 6255: inv_genealogy_pub.insert_genealogy( p_api_version =>1.0,

6251: l_ret_status := 'E'; -- fnd error status...
6252:
6253: l_stmt_num := 350;
6254:
6255: inv_genealogy_pub.insert_genealogy( p_api_version =>1.0,
6256:
6257: p_object_type =>5,
6258: p_object_id =>l_sj_gen_object_id,
6259: p_object_number =>p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_name,

Line 6286: p_msg_text => 'inv_genealogy_pub.insert_genealogy returned success',

6282: IF (l_ret_status = 'S') THEN
6283: if( g_log_level_statement >= l_log_level ) then
6284: l_msg_tokens.delete;
6285: WSM_log_PVT.logMessage(p_module_name => l_module ,
6286: p_msg_text => 'inv_genealogy_pub.insert_genealogy returned success',
6287: p_stmt_num => l_stmt_num ,
6288: p_msg_tokens => l_msg_tokens,
6289: p_fnd_log_level => g_log_level_statement,
6290: p_run_log_level => l_log_level

Line 6300: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',

6296: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6297:
6298: l_msg_tokens.delete;
6299: WSM_log_PVT.logMessage(p_module_name => l_module ,
6300: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',
6301: p_stmt_num => l_stmt_num ,
6302: p_msg_tokens => l_msg_tokens,
6303: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6304: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

Line 6313: l_err_buf := 'Error in inv_genealogy_pub.insert_genealogy: '||l_msg_data;

6309:
6310: l_stmt_num := 370;
6311: IF (l_msg_count = 1) THEN
6312: l_err_code := -1;
6313: l_err_buf := 'Error in inv_genealogy_pub.insert_genealogy: '||l_msg_data;
6314:
6315: ELSE
6316: FOR i IN 1..l_msg_count LOOP
6317: l_err_code := -1;

Line 6322: l_err_buf := 'Multiple errors in inv_genealogy_pub.insert_genealogy - populated in the log file';

6318: l_err_buf := fnd_msg_pub.get;
6319:
6320: END LOOP;
6321:
6322: l_err_buf := 'Multiple errors in inv_genealogy_pub.insert_genealogy - populated in the log file';
6323:
6324: END IF;
6325: RAISE FND_API.G_EXC_ERROR;
6326: END IF;

Line 6359: inv_genealogy_pub.insert_genealogy( p_api_version =>1.0,

6355: l_ret_status := 'E'; -- fnd error status...
6356:
6357: l_stmt_num := 373;
6358:
6359: inv_genealogy_pub.insert_genealogy( p_api_version =>1.0,
6360:
6361: p_object_type =>5,
6362: p_object_id =>l_sj_gen_object_id,
6363: p_object_number =>p_wltx_starting_jobs_tbl(l_job_counter).wip_entity_name,

Line 6392: p_msg_text => 'inv_genealogy_pub.insert_genealogy returned success',

6388: IF (l_ret_status = 'S') THEN
6389: if( g_log_level_statement >= l_log_level ) then
6390: l_msg_tokens.delete;
6391: WSM_log_PVT.logMessage(p_module_name => l_module ,
6392: p_msg_text => 'inv_genealogy_pub.insert_genealogy returned success',
6393: p_stmt_num => l_stmt_num ,
6394: p_msg_tokens => l_msg_tokens,
6395: p_fnd_log_level => g_log_level_statement,
6396: p_run_log_level => l_log_level

Line 6404: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',

6400: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6401:
6402: l_msg_tokens.delete;
6403: WSM_log_PVT.logMessage(p_module_name => l_module ,
6404: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',
6405: p_stmt_num => l_stmt_num ,
6406: p_msg_tokens => l_msg_tokens,
6407: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6408: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

Line 6416: l_err_buf := 'Error in inv_genealogy_pub.insert_genealogy: '||l_msg_data;

6412:
6413: l_stmt_num := 375;
6414: IF (l_msg_count = 1) THEN
6415: l_err_code := -1;
6416: l_err_buf := 'Error in inv_genealogy_pub.insert_genealogy: '||l_msg_data;
6417: ELSE
6418: FOR i IN 1..l_msg_count LOOP
6419: l_err_code := -1;
6420: l_err_buf := fnd_msg_pub.get;

Line 6423: l_err_buf := 'Multiple errors in inv_genealogy_pub.insert_genealogy - populated in the log file';

6419: l_err_code := -1;
6420: l_err_buf := fnd_msg_pub.get;
6421: END LOOP;
6422:
6423: l_err_buf := 'Multiple errors in inv_genealogy_pub.insert_genealogy - populated in the log file';
6424:
6425: END IF;
6426: RAISE FND_API.G_EXC_ERROR;
6427: END IF;