DBA Data[Home] [Help]

APPS.CSTPPWAC dependencies on FND_API

Line 126: raise fnd_api.g_exc_unexpected_error;

122: i_prg_appl_id, i_prg_id, i_txn_category,
123: l_err_num, l_err_code, l_err_msg);
124: if (l_err_num <> 0) then
125: -- Error occured
126: raise fnd_api.g_exc_unexpected_error;
127: end if;
128: */
129:
130: -- No need to process cost update

Line 176: raise fnd_api.g_exc_unexpected_error;

172: end if;
173:
174: if (l_err_num <> 0) then
175: -- Error occured
176: raise fnd_api.g_exc_unexpected_error;
177: end if;
178:
179: /*
180: -- Updating txn history table

Line 186: raise fnd_api.g_exc_unexpected_error;

182: i_user_id, i_login_id, i_req_id, i_prg_appl_id, i_prg_id,
183: l_err_num, l_err_code, l_err_msg);
184: if (l_err_num <> 0) then
185: -- Error occured
186: raise fnd_api.g_exc_unexpected_error;
187: end if;
188: */
189:
190: GOTO out_arg_log;

Line 242: raise fnd_api.g_exc_unexpected_error;

238: l_err_msg);
239:
240: if (l_err_num <> 0) then
241: -- Error occured
242: raise fnd_api.g_exc_unexpected_error;
243: end if;
244: end if;
245:
246: if (l_hook = -1) then

Line 305: raise fnd_api.g_exc_unexpected_error;

301: end if;
302:
303: if (l_err_num <> 0) then
304: -- Error occured
305: raise fnd_api.g_exc_unexpected_error;
306: end if;
307:
308: else
309: -- user populated actual cost.

Line 322: raise fnd_api.g_exc_unexpected_error;

318: i_user_id, i_login_id, i_req_id, i_prg_appl_id, i_prg_id,
319: l_err_num, l_err_code, l_err_msg);
320: if (l_err_num <> 0) then
321: -- Error occured
322: raise fnd_api.g_exc_unexpected_error;
323: end if;
324: */
325:
326: GOTO out_arg_log;

Line 369: raise fnd_api.g_exc_unexpected_error;

365: l_err_msg);
366:
367: if (l_err_num <> 0) then
368: -- Error occured
369: raise fnd_api.g_exc_unexpected_error;
370: end if;
371:
372: -- InterOrg Transfer across cost groups(ownership changes)
373: -- INVCONV sikhanna adding 15 and 22 (as these will be across CG's only)

Line 406: raise fnd_api.g_exc_unexpected_error;

402: l_err_msg);
403:
404: if (l_err_num <> 0) then
405: -- Error occured
406: raise fnd_api.g_exc_unexpected_error;
407: end if;
408:
409: -- The Group 1 and 1' transactions
410: elsif (i_process_group = 1) then

Line 467: raise fnd_api.g_exc_unexpected_error;

463: l_err_msg);
464:
465: if (l_err_num <> 0) then
466: -- Error occured
467: raise fnd_api.g_exc_unexpected_error;
468: end if;
469: end if; -- end of if clause for bug 2541342
470:
471:

Line 507: raise fnd_api.g_exc_unexpected_error;

503: l_err_msg);
504:
505: if (l_err_num <> 0) then
506: -- Error occured
507: raise fnd_api.g_exc_unexpected_error;
508: end if;
509:
510: end if;
511:

Line 519: raise fnd_api.g_exc_unexpected_error;

515: i_user_id, i_login_id, i_req_id, i_prg_appl_id, i_prg_id,
516: l_err_num, l_err_code, l_err_msg);
517: if (l_err_num <> 0) then
518: -- Error occured
519: raise fnd_api.g_exc_unexpected_error;
520: end if;
521: */
522:
523: /* --- start of auto log --- */

Line 539: WHEN fnd_api.g_exc_unexpected_error THEN

535: END IF;
536: /* --- end of auto log --- */
537: EXCEPTION
538: /* --- start of auto log --- */
539: WHEN fnd_api.g_exc_unexpected_error THEN
540: IF l_exceptionlog THEN
541: fnd_msg_pub.add_exc_msg(
542: p_pkg_name => 'CSTPPWAC',
543: p_procedure_name => 'cost_processor',

Line 705: raise fnd_api.g_exc_unexpected_error;

701: end if;
702:
703: if (l_err_num <> 0) then
704: -- Error occured
705: raise fnd_api.g_exc_unexpected_error;
706: end if;
707:
708: /* --- start of auto log --- */
709: <>

Line 724: WHEN fnd_api.g_exc_unexpected_error THEN

720: END IF;
721: /* --- end of auto log --- */
722: EXCEPTION
723: /* --- start of auto log --- */
724: WHEN fnd_api.g_exc_unexpected_error THEN
725: IF l_exceptionlog THEN
726: fnd_msg_pub.add_exc_msg(
727: p_pkg_name => 'CSTPPWAC',
728: p_procedure_name => 'cost_owned_txns',

Line 890: raise fnd_api.g_exc_unexpected_error;

886: end if;
887:
888: if (l_err_num <> 0) then
889: -- Error occured
890: raise fnd_api.g_exc_unexpected_error;
891: end if;
892:
893: /* --- start of auto log --- */
894: <>

Line 909: WHEN fnd_api.g_exc_unexpected_error THEN

905: END IF;
906: /* --- end of auto log --- */
907: EXCEPTION
908: /* --- start of auto log --- */
909: WHEN fnd_api.g_exc_unexpected_error THEN
910: IF l_exceptionlog THEN
911: fnd_msg_pub.add_exc_msg(
912: p_pkg_name => 'CSTPPWAC',
913: p_procedure_name => 'cost_derived_txns',

Line 1127: raise fnd_api.g_exc_unexpected_error;

1123: l_err_msg);
1124:
1125: if (l_err_num <> 0) then
1126: -- Error occured
1127: raise fnd_api.g_exc_unexpected_error;
1128: end if;
1129:
1130: /* --- start of auto log --- */
1131: <>

Line 1146: WHEN fnd_api.g_exc_unexpected_error THEN

1142: END IF;
1143: /* --- end of auto log --- */
1144: EXCEPTION
1145: /* --- start of auto log --- */
1146: WHEN fnd_api.g_exc_unexpected_error THEN
1147: IF l_exceptionlog THEN
1148: fnd_msg_pub.add_exc_msg(
1149: p_pkg_name => 'CSTPPWAC',
1150: p_procedure_name => 'sub_transfer',

Line 1344: raise fnd_api.g_exc_unexpected_error;

1340: l_err_msg);
1341:
1342: if (l_err_num <> 0) then
1343: -- Error occured
1344: raise fnd_api.g_exc_unexpected_error;
1345: end if;
1346:
1347:
1348: -- 1) The Direct Interorg Shipment

Line 1392: raise fnd_api.g_exc_unexpected_error;

1388: l_err_msg);
1389:
1390: if (l_err_num <> 0) then
1391: -- Error occured
1392: raise fnd_api.g_exc_unexpected_error;
1393: end if;
1394:
1395:
1396: end if;

Line 1414: WHEN fnd_api.g_exc_unexpected_error THEN

1410: END IF;
1411: /* --- end of auto log --- */
1412: EXCEPTION
1413: /* --- start of auto log --- */
1414: WHEN fnd_api.g_exc_unexpected_error THEN
1415: IF l_exceptionlog THEN
1416: fnd_msg_pub.add_exc_msg(
1417: p_pkg_name => 'CSTPPWAC',
1418: p_procedure_name => 'interorg',

Line 1492: l_return_status VARCHAR(1) := FND_API.G_RET_STS_SUCCESS;

1488:
1489: -- Variables defined for eAM Support in PAC
1490: l_eam_job NUMBER;
1491: l_zero_cost_flag NUMBER;
1492: l_return_status VARCHAR(1) := FND_API.G_RET_STS_SUCCESS;
1493: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1494: l_msg_count NUMBER;
1495: l_msg_data VARCHAR2(8000) := '';
1496: l_api_message VARCHAR2(1000) := '';

Line 1493: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1489: -- Variables defined for eAM Support in PAC
1490: l_eam_job NUMBER;
1491: l_zero_cost_flag NUMBER;
1492: l_return_status VARCHAR(1) := FND_API.G_RET_STS_SUCCESS;
1493: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1494: l_msg_count NUMBER;
1495: l_msg_data VARCHAR2(8000) := '';
1496: l_api_message VARCHAR2(1000) := '';
1497:

Line 1665: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1661: p_txn_id => i_txn_id,
1662: x_zero_cost_flag => l_zero_cost_flag
1663: );
1664:
1665: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1666: l_err_num := -4321; -- Giving a number which is non-zero
1667: l_err_code := l_msg_count;
1668: l_err_msg := 'get_zeroCostIssue_flag returned unexpected error';
1669: RAISE fnd_api.g_exc_unexpected_error;

Line 1669: RAISE fnd_api.g_exc_unexpected_error;

1665: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1666: l_err_num := -4321; -- Giving a number which is non-zero
1667: l_err_code := l_msg_count;
1668: l_err_msg := 'get_zeroCostIssue_flag returned unexpected error';
1669: RAISE fnd_api.g_exc_unexpected_error;
1670: END IF;
1671:
1672: END IF;
1673:

Line 1821: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1817: x_return_status => l_return_status,
1818: x_msg_count => l_msg_count,
1819: x_msg_data => l_err_msg
1820: );
1821: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1822: -- Error occured
1823: RAISE fnd_api.g_exc_unexpected_error;
1824: END IF;
1825:

Line 1823: RAISE fnd_api.g_exc_unexpected_error;

1819: x_msg_data => l_err_msg
1820: );
1821: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1822: -- Error occured
1823: RAISE fnd_api.g_exc_unexpected_error;
1824: END IF;
1825:
1826: IF (l_earn_moh = 1) THEN
1827:

Line 1854: raise fnd_api.g_exc_unexpected_error;

1850: l_err_msg);
1851:
1852: if (l_err_num <> 0) then
1853: -- Error occured
1854: raise fnd_api.g_exc_unexpected_error;
1855: end if;
1856: l_ret_val := 1;
1857:
1858: end if;

Line 1880: WHEN fnd_api.g_exc_unexpected_error THEN

1876: return l_ret_val;
1877:
1878: EXCEPTION
1879: /* --- start of auto log --- */
1880: WHEN fnd_api.g_exc_unexpected_error THEN
1881: IF l_exceptionlog THEN
1882: fnd_msg_pub.add_exc_msg(
1883: p_pkg_name => 'CSTPPWAC',
1884: p_procedure_name => 'compute_pwac_cost',

Line 2387: WHEN fnd_api.g_exc_unexpected_error THEN

2383: END IF;
2384: /* --- end of auto log --- */
2385: EXCEPTION
2386: /* --- start of auto log --- */
2387: WHEN fnd_api.g_exc_unexpected_error THEN
2388: IF l_exceptionlog THEN
2389: fnd_msg_pub.add_exc_msg(
2390: p_pkg_name => 'CSTPPWAC',
2391: p_procedure_name => 'current_pwac_cost',

Line 2673: WHEN fnd_api.g_exc_unexpected_error THEN

2669: END IF;
2670: /* --- end of auto log --- */
2671: EXCEPTION
2672: /* --- start of auto log --- */
2673: WHEN fnd_api.g_exc_unexpected_error THEN
2674: IF l_exceptionlog THEN
2675: fnd_msg_pub.add_exc_msg(
2676: p_pkg_name => 'CSTPPWAC',
2677: p_procedure_name => 'calc_pwac_cost',