DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on FND_MSG_PUB

Line 2521: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2517: RETURN(l_archive_total_amt);
2518:
2519: EXCEPTION
2520: WHEN OTHERS THEN
2521: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2522: THEN
2523: fnd_msg_pub.add_exc_msg (g_pkg_name, 'GET_ARCHIVE_TOTAL',
2524: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
2525: END IF;

Line 2523: fnd_msg_pub.add_exc_msg (g_pkg_name, 'GET_ARCHIVE_TOTAL',

2519: EXCEPTION
2520: WHEN OTHERS THEN
2521: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2522: THEN
2523: fnd_msg_pub.add_exc_msg (g_pkg_name, 'GET_ARCHIVE_TOTAL',
2524: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
2525: END IF;
2526: RETURN(0);
2527: END get_archive_total;

Line 2995: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2991: RETURN(l_archive_total_amt);
2992:
2993: EXCEPTION
2994: WHEN OTHERS THEN
2995: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2996: THEN
2997: fnd_msg_pub.add_exc_msg (g_pkg_name, 'GET_ARCHIVE_TOTAL_FOR_ANY_REV',
2998: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
2999: END IF;

Line 2997: fnd_msg_pub.add_exc_msg (g_pkg_name, 'GET_ARCHIVE_TOTAL_FOR_ANY_REV',

2993: EXCEPTION
2994: WHEN OTHERS THEN
2995: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2996: THEN
2997: fnd_msg_pub.add_exc_msg (g_pkg_name, 'GET_ARCHIVE_TOTAL_FOR_ANY_REV',
2998: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
2999: END IF;
3000: RETURN(0);
3001: END get_archive_total_for_any_rev;

Line 6013: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

6009: l_Unique:= FALSE;
6010: RETURN(l_Unique);
6011: WHEN OTHERS THEN
6012: l_unique := FALSE;
6013: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
6014: THEN
6015: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name,
6016: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
6017: END IF;

Line 6015: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name,

6011: WHEN OTHERS THEN
6012: l_unique := FALSE;
6013: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
6014: THEN
6015: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name,
6016: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
6017: END IF;
6018: RETURN(l_Unique);
6019: END Check_doc_number_Unique;

Line 6028: -- FND_MSG_PUB

6024: --Pre-reqs:
6025: -- None.
6026: --Modifies:
6027: -- FND_LOG
6028: -- FND_MSG_PUB
6029: --Locks:
6030: -- None.
6031: --Function:
6032: -- Checks if p_inv_org_id is in the Set of Books p_sob_id. If p_sob_id

Line 6123: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,

6119: EXCEPTION
6120: WHEN OTHERS THEN
6121: x_return_status := FND_API.g_ret_sts_unexp_error;
6122: x_in_sob := FALSE;
6123: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
6124: p_procedure_name => 'check_inv_org_in_sob',
6125: p_error_text => 'Progress: '||l_progress||
6126: ' Error: '||SUBSTRB(SQLERRM,1,215));
6127: IF g_debug_unexp THEN

Line 6141: -- FND_MSG_PUB

6137: --Pre-reqs:
6138: -- None.
6139: --Modifies:
6140: -- FND_LOG
6141: -- FND_MSG_PUB
6142: --Locks:
6143: -- None.
6144: --Function:
6145: -- Gets the operating unit associated with p_inv_org_id. If p_inv_org_id is

Line 6213: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,

6209:
6210: EXCEPTION
6211: WHEN OTHERS THEN
6212: x_return_status := FND_API.g_ret_sts_unexp_error;
6213: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
6214: p_procedure_name => 'get_inv_org_ou_id',
6215: p_error_text => 'Progress: '||l_progress||
6216: ' Error: '||SUBSTRB(SQLERRM,1,215));
6217: IF g_debug_unexp THEN

Line 6231: -- FND_MSG_PUB

6227: --Pre-reqs:
6228: -- None.
6229: --Modifies:
6230: -- FND_LOG
6231: -- FND_MSG_PUB
6232: --Locks:
6233: -- None.
6234: --Function:
6235: -- Gets the set of books ID associated with p_inv_org_id. Appends to the

Line 6293: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,

6289:
6290: EXCEPTION
6291: WHEN OTHERS THEN
6292: x_return_status := FND_API.g_ret_sts_unexp_error;
6293: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
6294: p_procedure_name => 'get_inv_org_sob_id',
6295: p_error_text => 'Progress: '||l_progress||
6296: ' Error: '||SUBSTRB(SQLERRM,1,215));
6297: IF g_debug_unexp THEN

Line 6311: -- FND_MSG_PUB

6307: --Pre-reqs:
6308: -- None.
6309: --Modifies:
6310: -- FND_LOG
6311: -- FND_MSG_PUB
6312: --Locks:
6313: -- None.
6314: --Function:
6315: -- Gets the following information associated with p_inv_org_id:

Line 6405: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,

6401:
6402: EXCEPTION
6403: WHEN OTHERS THEN
6404: x_return_status := FND_API.g_ret_sts_unexp_error;
6405: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
6406: p_procedure_name => 'get_inv_org_info',
6407: p_error_text => 'Progress: '||l_progress||
6408: ' Error: '||SUBSTRB(SQLERRM,1,215));
6409: IF g_debug_unexp THEN

Line 7103: FND_MSG_PUB.add;

7099:
7100: FND_MESSAGE.set_name('PO', 'PO_INVALID_YES_NO_PARAM');
7101: FND_MESSAGE.set_token('PARAMETER_NAME', p_parameter_name);
7102: FND_MESSAGE.set_token('PARAMETER_VALUE', p_parameter_value);
7103: FND_MSG_PUB.add;
7104:
7105: x_return_status := FND_API.G_RET_STS_ERROR;
7106: RETURN;
7107: END IF;

Line 8073: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_module_name|| ':'||d_pos);

8069: END IF;
8070: return(doc_last_update_date);
8071: EXCEPTION
8072: WHEN OTHERS THEN
8073: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_module_name|| ':'||d_pos);
8074: IF (PO_LOG.d_exc) THEN
8075: PO_LOG.exc(d_module_base, d_pos, SQLCODE || SQLERRM);
8076: END IF;
8077: RAISE;

Line 8306: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_module_name|| ':'||d_pos);

8302: END IF;
8303: return(mod_last_update_date);
8304: EXCEPTION
8305: WHEN OTHERS THEN
8306: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_module_name|| ':'||d_pos);
8307: IF (PO_LOG.d_exc) THEN
8308: PO_LOG.exc(d_module_base, d_pos, SQLCODE || SQLERRM);
8309: END IF;
8310: RAISE;