DBA Data[Home] [Help]

APPS.WIP_MTLTEMPPROC_PRIV dependencies on FND_MESSAGE

Line 70: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

66:
67: --for some reason TM errors clear the stack so we must put the
68: --error message back, but successful txns do not clear the stack
69: if(l_retCode <> 0) then
70: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
71: fnd_message.set_token('MESSAGE', l_errMsg);
72: fnd_msg_pub.add;
73: wip_utilities.get_message_stack(p_msg => x_errorMsg,
74: p_delete_stack => fnd_api.g_false);

Line 71: fnd_message.set_token('MESSAGE', l_errMsg);

67: --for some reason TM errors clear the stack so we must put the
68: --error message back, but successful txns do not clear the stack
69: if(l_retCode <> 0) then
70: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
71: fnd_message.set_token('MESSAGE', l_errMsg);
72: fnd_msg_pub.add;
73: wip_utilities.get_message_stack(p_msg => x_errorMsg,
74: p_delete_stack => fnd_api.g_false);
75: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

Line 122: fnd_message.set_name('WIP', 'MTL_PROC_FAIL');

118: p_error_text => SQLERRM);
119: wip_utilities.get_message_stack(p_msg => x_errorMsg,
120: p_delete_stack => fnd_api.g_false,
121: p_separator => ' ');
122: fnd_message.set_name('WIP', 'MTL_PROC_FAIL');
123: l_errCode := fnd_message.get;
124:
125: update mtl_material_transactions_temp
126: set process_flag = 'E',

Line 123: l_errCode := fnd_message.get;

119: wip_utilities.get_message_stack(p_msg => x_errorMsg,
120: p_delete_stack => fnd_api.g_false,
121: p_separator => ' ');
122: fnd_message.set_name('WIP', 'MTL_PROC_FAIL');
123: l_errCode := fnd_message.get;
124:
125: update mtl_material_transactions_temp
126: set process_flag = 'E',
127: error_code = substr(l_errCode,1,240),

Line 512: fnd_message.set_name('WIP', 'WIP_TMPINSERT_ERR');

508: and mti.inventory_item_id = msik.inventory_item_id
509: and mti.organization_id = msik.organization_id;
510:
511: for i in 1..l_itemNameTbl.count loop
512: fnd_message.set_name('WIP', 'WIP_TMPINSERT_ERR');
513: fnd_message.set_token('ITEM_NAME', l_itemNameTbl(i));
514: fnd_message.set_token('ERR_MSG', l_errExplTbl(i));
515: if(l_logLevel <= wip_constants.trace_logging) then
516: wip_logger.log('item ' || l_itemNameTbl(i) || ': ' || l_errExplTbl(i), l_retStatus);

Line 513: fnd_message.set_token('ITEM_NAME', l_itemNameTbl(i));

509: and mti.organization_id = msik.organization_id;
510:
511: for i in 1..l_itemNameTbl.count loop
512: fnd_message.set_name('WIP', 'WIP_TMPINSERT_ERR');
513: fnd_message.set_token('ITEM_NAME', l_itemNameTbl(i));
514: fnd_message.set_token('ERR_MSG', l_errExplTbl(i));
515: if(l_logLevel <= wip_constants.trace_logging) then
516: wip_logger.log('item ' || l_itemNameTbl(i) || ': ' || l_errExplTbl(i), l_retStatus);
517: end if;

Line 514: fnd_message.set_token('ERR_MSG', l_errExplTbl(i));

510:
511: for i in 1..l_itemNameTbl.count loop
512: fnd_message.set_name('WIP', 'WIP_TMPINSERT_ERR');
513: fnd_message.set_token('ITEM_NAME', l_itemNameTbl(i));
514: fnd_message.set_token('ERR_MSG', l_errExplTbl(i));
515: if(l_logLevel <= wip_constants.trace_logging) then
516: wip_logger.log('item ' || l_itemNameTbl(i) || ': ' || l_errExplTbl(i), l_retStatus);
517: end if;
518: fnd_msg_pub.add;

Line 559: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

555: where transaction_header_id = p_txnHdrID;
556: end if;
557:
558: if(l_msgData is not null) then
559: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
560: fnd_message.set_token('MESSAGE', l_msgData);
561: fnd_msg_pub.add;
562: end if;
563: if(l_logLevel <= wip_constants.trace_logging) then

Line 560: fnd_message.set_token('MESSAGE', l_msgData);

556: end if;
557:
558: if(l_msgData is not null) then
559: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
560: fnd_message.set_token('MESSAGE', l_msgData);
561: fnd_msg_pub.add;
562: end if;
563: if(l_logLevel <= wip_constants.trace_logging) then
564: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,