DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on FND_MSG_PUB

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

2385: RETURN(l_archive_total_amt);
2386:
2387: EXCEPTION
2388: WHEN OTHERS THEN
2389: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2390: THEN
2391: fnd_msg_pub.add_exc_msg (g_pkg_name, 'GET_ARCHIVE_TOTAL',
2392: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
2393: END IF;

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

2387: EXCEPTION
2388: WHEN OTHERS THEN
2389: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2390: THEN
2391: fnd_msg_pub.add_exc_msg (g_pkg_name, 'GET_ARCHIVE_TOTAL',
2392: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
2393: END IF;
2394: RETURN(0);
2395: END get_archive_total;

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

2859: RETURN(l_archive_total_amt);
2860:
2861: EXCEPTION
2862: WHEN OTHERS THEN
2863: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2864: THEN
2865: fnd_msg_pub.add_exc_msg (g_pkg_name, 'GET_ARCHIVE_TOTAL_FOR_ANY_REV',
2866: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
2867: END IF;

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

2861: EXCEPTION
2862: WHEN OTHERS THEN
2863: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2864: THEN
2865: fnd_msg_pub.add_exc_msg (g_pkg_name, 'GET_ARCHIVE_TOTAL_FOR_ANY_REV',
2866: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
2867: END IF;
2868: RETURN(0);
2869: END get_archive_total_for_any_rev;

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

5801: l_Unique:= FALSE;
5802: RETURN(l_Unique);
5803: WHEN OTHERS THEN
5804: l_unique := FALSE;
5805: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
5806: THEN
5807: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name,
5808: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
5809: END IF;

Line 5807: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name,

5803: WHEN OTHERS THEN
5804: l_unique := FALSE;
5805: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
5806: THEN
5807: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name,
5808: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
5809: END IF;
5810: RETURN(l_Unique);
5811: END Check_doc_number_Unique;

Line 5820: -- FND_MSG_PUB

5816: --Pre-reqs:
5817: -- None.
5818: --Modifies:
5819: -- FND_LOG
5820: -- FND_MSG_PUB
5821: --Locks:
5822: -- None.
5823: --Function:
5824: -- Checks if p_inv_org_id is in the Set of Books p_sob_id. If p_sob_id

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

5911: EXCEPTION
5912: WHEN OTHERS THEN
5913: x_return_status := FND_API.g_ret_sts_unexp_error;
5914: x_in_sob := FALSE;
5915: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
5916: p_procedure_name => 'check_inv_org_in_sob',
5917: p_error_text => 'Progress: '||l_progress||
5918: ' Error: '||SUBSTRB(SQLERRM,1,215));
5919: IF g_debug_unexp THEN

Line 5933: -- FND_MSG_PUB

5929: --Pre-reqs:
5930: -- None.
5931: --Modifies:
5932: -- FND_LOG
5933: -- FND_MSG_PUB
5934: --Locks:
5935: -- None.
5936: --Function:
5937: -- Gets the operating unit associated with p_inv_org_id. If p_inv_org_id is

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

6001:
6002: EXCEPTION
6003: WHEN OTHERS THEN
6004: x_return_status := FND_API.g_ret_sts_unexp_error;
6005: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
6006: p_procedure_name => 'get_inv_org_ou_id',
6007: p_error_text => 'Progress: '||l_progress||
6008: ' Error: '||SUBSTRB(SQLERRM,1,215));
6009: IF g_debug_unexp THEN

Line 6023: -- FND_MSG_PUB

6019: --Pre-reqs:
6020: -- None.
6021: --Modifies:
6022: -- FND_LOG
6023: -- FND_MSG_PUB
6024: --Locks:
6025: -- None.
6026: --Function:
6027: -- Gets the set of books ID associated with p_inv_org_id. Appends to the

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

6081:
6082: EXCEPTION
6083: WHEN OTHERS THEN
6084: x_return_status := FND_API.g_ret_sts_unexp_error;
6085: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
6086: p_procedure_name => 'get_inv_org_sob_id',
6087: p_error_text => 'Progress: '||l_progress||
6088: ' Error: '||SUBSTRB(SQLERRM,1,215));
6089: IF g_debug_unexp THEN

Line 6103: -- FND_MSG_PUB

6099: --Pre-reqs:
6100: -- None.
6101: --Modifies:
6102: -- FND_LOG
6103: -- FND_MSG_PUB
6104: --Locks:
6105: -- None.
6106: --Function:
6107: -- Gets the following information associated with p_inv_org_id:

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

6193:
6194: EXCEPTION
6195: WHEN OTHERS THEN
6196: x_return_status := FND_API.g_ret_sts_unexp_error;
6197: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
6198: p_procedure_name => 'get_inv_org_info',
6199: p_error_text => 'Progress: '||l_progress||
6200: ' Error: '||SUBSTRB(SQLERRM,1,215));
6201: IF g_debug_unexp THEN

Line 6895: FND_MSG_PUB.add;

6891:
6892: FND_MESSAGE.set_name('PO', 'PO_INVALID_YES_NO_PARAM');
6893: FND_MESSAGE.set_token('PARAMETER_NAME', p_parameter_name);
6894: FND_MESSAGE.set_token('PARAMETER_VALUE', p_parameter_value);
6895: FND_MSG_PUB.add;
6896:
6897: x_return_status := FND_API.G_RET_STS_ERROR;
6898: RETURN;
6899: END IF;

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

7861: END IF;
7862: return(doc_last_update_date);
7863: EXCEPTION
7864: WHEN OTHERS THEN
7865: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_module_name|| ':'||d_pos);
7866: IF (PO_LOG.d_exc) THEN
7867: PO_LOG.exc(d_module_base, d_pos, SQLCODE || SQLERRM);
7868: END IF;
7869: RAISE;