DBA Data[Home] [Help]

APPS.WSMPJUPD dependencies on INV_GENEALOGY_PUB

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

6315: l_ret_status := 'E'; -- fnd error status...
6316:
6317: l_stmt_num := 350;
6318:
6319: inv_genealogy_pub.insert_genealogy( p_api_version =>1.0,
6320:
6321: p_object_type =>5,
6322: p_object_id =>l_sj_gen_object_id,
6323: p_object_number =>p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_name,

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

6346: IF (l_ret_status = 'S') THEN
6347: if( g_log_level_statement >= l_log_level ) then
6348: l_msg_tokens.delete;
6349: WSM_log_PVT.logMessage(p_module_name => l_module ,
6350: p_msg_text => 'inv_genealogy_pub.insert_genealogy returned success',
6351: p_stmt_num => l_stmt_num ,
6352: p_msg_tokens => l_msg_tokens,
6353: p_fnd_log_level => g_log_level_statement,
6354: p_run_log_level => l_log_level

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

6360: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6361:
6362: l_msg_tokens.delete;
6363: WSM_log_PVT.logMessage(p_module_name => l_module ,
6364: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',
6365: p_stmt_num => l_stmt_num ,
6366: p_msg_tokens => l_msg_tokens,
6367: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6368: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

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

6373:
6374: l_stmt_num := 370;
6375: IF (l_msg_count = 1) THEN
6376: l_err_code := -1;
6377: l_err_buf := 'Error in inv_genealogy_pub.insert_genealogy: '||l_msg_data;
6378:
6379: ELSE
6380: FOR i IN 1..l_msg_count LOOP
6381: l_err_code := -1;

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

6382: l_err_buf := fnd_msg_pub.get;
6383:
6384: END LOOP;
6385:
6386: l_err_buf := 'Multiple errors in inv_genealogy_pub.insert_genealogy - populated in the log file';
6387:
6388: END IF;
6389: RAISE FND_API.G_EXC_ERROR;
6390: END IF;

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

6419: l_ret_status := 'E'; -- fnd error status...
6420:
6421: l_stmt_num := 373;
6422:
6423: inv_genealogy_pub.insert_genealogy( p_api_version =>1.0,
6424:
6425: p_object_type =>5,
6426: p_object_id =>l_sj_gen_object_id,
6427: p_object_number =>p_wltx_starting_jobs_tbl(l_job_counter).wip_entity_name,

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

6452: IF (l_ret_status = 'S') THEN
6453: if( g_log_level_statement >= l_log_level ) then
6454: l_msg_tokens.delete;
6455: WSM_log_PVT.logMessage(p_module_name => l_module ,
6456: p_msg_text => 'inv_genealogy_pub.insert_genealogy returned success',
6457: p_stmt_num => l_stmt_num ,
6458: p_msg_tokens => l_msg_tokens,
6459: p_fnd_log_level => g_log_level_statement,
6460: p_run_log_level => l_log_level

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

6464: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6465:
6466: l_msg_tokens.delete;
6467: WSM_log_PVT.logMessage(p_module_name => l_module ,
6468: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',
6469: p_stmt_num => l_stmt_num ,
6470: p_msg_tokens => l_msg_tokens,
6471: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6472: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

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

6476:
6477: l_stmt_num := 375;
6478: IF (l_msg_count = 1) THEN
6479: l_err_code := -1;
6480: l_err_buf := 'Error in inv_genealogy_pub.insert_genealogy: '||l_msg_data;
6481: ELSE
6482: FOR i IN 1..l_msg_count LOOP
6483: l_err_code := -1;
6484: l_err_buf := fnd_msg_pub.get;

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

6483: l_err_code := -1;
6484: l_err_buf := fnd_msg_pub.get;
6485: END LOOP;
6486:
6487: l_err_buf := 'Multiple errors in inv_genealogy_pub.insert_genealogy - populated in the log file';
6488:
6489: END IF;
6490: RAISE FND_API.G_EXC_ERROR;
6491: END IF;