APPS.CST_PACEAMCOST_GRP dependencies on FND_MSG_PUB

Line 175: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

171:
172: l_api_message := ' ( ' || to_char(l_stmt_num) || ' ): '
173: || 'Invalid Program Argument Combination';
174:
175: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
176: l_api_name,
177: l_api_message);
178:
179: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',

Line 429: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

425:
426: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
427: l_api_message := 'CST_PacEamCost_GRP.delete_PacEamPerBal() failed';
428: l_msg_data := l_api_message;
429: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
430: l_api_name,
431: '('|| to_char(l_stmt_num) || '): '|| l_api_message);
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; -- ERROR rollback and exit
433: END IF;

Line 467: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name,

463:
464: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
465: l_api_message := 'CST_PacEamCost_GRP.delete_PAC_EamBalAcct() failed';
466: l_msg_data := l_api_message;
467: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name,
468: '('|| to_char(l_stmt_num) || '): '|| l_api_message);
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; -- ERROR rollback and exit
470: END IF;
471:

Line 510: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('

506: IF l_return_status <> FND_API.g_ret_sts_success THEN
507:
508: l_api_message := 'Error: CST_eamCost_PUB.Insert_tempEstimateDetails()';
509:
510: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('
511: ||TO_CHAR(l_stmt_num)
512: ||'): ', l_api_message);
513: RAISE FND_API.g_exc_error;
514:

Line 573: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

569: l_stmt_num := 80;
570:
571: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
572: l_api_message := 'CST_PacEamCost_GRP.Compute_PAC_JobEstimates failed';
573: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
574: l_api_name,
575: '('|| to_char(l_stmt_num) || '): '|| l_api_message);
576: RAISE PROCESS_ERROR;
577: END IF;

Line 700: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

696: END IF;
697:
698: l_api_message := '(' || TO_CHAR(l_stmt_num) || ') : '|| SUBSTRB (SQLERRM , 1 , 240);
699:
700: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
701: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
702: l_api_name,
703: l_api_message);
704: END IF;

Line 701: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

697:
698: l_api_message := '(' || TO_CHAR(l_stmt_num) || ') : '|| SUBSTRB (SQLERRM , 1 , 240);
699:
700: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
701: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
702: l_api_name,
703: l_api_message);
704: END IF;
705:

Line 853: FND_MSG_PUB.initialize;

849: END IF;
850:
851: /* Initialize message list if p_init_msg_list is set to TRUE */
852: IF FND_API.to_Boolean(p_init_msg_list) THEN
853: FND_MSG_PUB.initialize;
854: END IF;
855:
856: /* Initialize API return status to success */
857: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1014: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

1010: WHEN FND_API.G_EXC_ERROR THEN
1011: ROLLBACK TO Delete_PAC_EamPerBal_PUB;
1012: x_return_status := FND_API.g_ret_sts_error;
1013: /* Get message count and data */
1014: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1015: p_data => x_msg_data);
1016:
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: ROLLBACK TO Delete_PAC_EamPerBal_PUB;

Line 1022: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

1018: ROLLBACK TO Delete_PAC_EamPerBal_PUB;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020:
1021: /* Get message count and data */
1022: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1023: p_data => x_msg_data);
1024:
1025: WHEN OTHERS THEN
1026: ROLLBACK TO Delete_PAC_EamPerBal_PUB;

Line 1036: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1032: l_module || '.' || l_stmt_num ,
1033: SUBSTRB (SQLERRM , 1 , 240));
1034: END IF;
1035:
1036: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1037: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1038: l_api_name,
1039: '(' || TO_CHAR(l_stmt_num) || ') : '
1040: || SUBSTRB (SQLERRM , 1 , 240));

Line 1037: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1033: SUBSTRB (SQLERRM , 1 , 240));
1034: END IF;
1035:
1036: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1037: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1038: l_api_name,
1039: '(' || TO_CHAR(l_stmt_num) || ') : '
1040: || SUBSTRB (SQLERRM , 1 , 240));
1041: END IF;

Line 1044: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

1040: || SUBSTRB (SQLERRM , 1 , 240));
1041: END IF;
1042:
1043: /* Get message count and data */
1044: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1045: p_data => x_msg_data);
1046:
1047: END Delete_PAC_EamPerBal;
1048:

Line 1558: FND_MSG_PUB.initialize;

1554: END IF;
1555:
1556: -- Initialize message list if p_init_msg_list is set to TRUE
1557: IF FND_API.to_Boolean(p_init_msg_list) THEN
1558: FND_MSG_PUB.initialize;
1559: END IF;
1560:
1561: -- initialize api return status to success
1562: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1617: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1613:
1614: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1615: l_api_message := 'CST_EAMCOST_PUB.get_charge_asset() returned error ' || l_api_message;
1616: l_msg_data := l_api_message;
1617: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1618: l_api_name,
1619: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
1620: || SUBSTRB (SQLERRM , 1 , 240));
1621: RAISE FND_API.G_EXC_ERROR;

Line 1780: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1776: l_stmt_num := 260;
1777: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1778: l_api_message := 'CST_EAMCOST_PUB.Get_MaintCostCat() returned error';
1779: l_msg_data := l_api_message;
1780: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1781: l_api_name,
1782: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
1783: || SUBSTRB (SQLERRM , 1 , 240));
1784: RAISE FND_API.G_EXC_ERROR;

Line 1798: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1794:
1795: IF l_eam_cost_element = 0 THEN
1796: l_api_message := 'CST_EAMCOST_PUB.Get_eamCostElement() returned error';
1797: l_msg_data := l_api_message;
1798: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1799: l_api_name,
1800: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
1801: || SUBSTRB (SQLERRM , 1 , 240));
1802: RAISE FND_API.G_EXC_ERROR;

Line 1838: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1834:
1835: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1836: l_api_message := 'insertupdate_PAC_eamperbal() returned error ';
1837: l_msg_data := l_api_message;
1838: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1839: l_api_name,
1840: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
1841: || SUBSTRB (SQLERRM , 1 , 240));
1842: RAISE FND_API.G_EXC_ERROR;

Line 1893: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('

1889:
1890: IF l_return_status <> FND_API.g_ret_sts_success THEN
1891:
1892: l_api_message := 'Insert_PAC_eamBalAcct error';
1893: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
1894: ||TO_CHAR(l_stmt_num)
1895: ||'): ', l_api_message);
1896: RAISE FND_API.g_exc_error;
1897:

Line 1951: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1947:
1948: IF l_return_status <> FND_API.g_ret_sts_success THEN
1949: l_api_message := 'insertupdate_PAC_eamperbal() returned error';
1950: l_msg_data := l_api_message;
1951: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1952: l_api_name,
1953: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
1954: || SUBSTRB (SQLERRM , 1 , 240));
1955: RAISE FND_API.G_EXC_ERROR;

Line 2000: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('

1996:
1997: IF l_return_status <> FND_API.g_ret_sts_success THEN
1998:
1999: l_api_message := 'Insert_PAC_eamBalAcct error';
2000: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2001: ||TO_CHAR(l_stmt_num)
2002: ||'): ', l_api_message);
2003: RAISE FND_API.g_exc_error;
2004:

Line 2040: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2036:
2037: IF l_return_status <> FND_API.g_ret_sts_success THEN
2038: l_api_message := 'CST_EAMCOST_PUB.Get_MaintCostCat() returned error';
2039: l_msg_data := l_api_message;
2040: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2041: l_api_name,
2042: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2043: || SUBSTRB (SQLERRM , 1 , 240));
2044: RAISE FND_API.G_EXC_ERROR;

Line 2059: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2055:
2056: IF l_eam_cost_element = 0 THEN
2057: l_api_message := 'CST_EAMCOST_PUB.Get_eamCostElement() returned error';
2058: l_msg_data := l_api_message;
2059: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2060: l_api_name,
2061: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2062: || SUBSTRB (SQLERRM , 1 , 240));
2063: RAISE FND_API.G_EXC_ERROR;

Line 2099: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2095:
2096: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2097: l_api_message := 'insertupdate_PAC_eamperbal() returned error';
2098: l_msg_data := l_api_message;
2099: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2100: l_api_name,
2101: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2102: || SUBSTRB (SQLERRM , 1 , 240));
2103: RAISE FND_API.G_EXC_ERROR;

Line 2210: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('

2206:
2207: IF l_return_status <> FND_API.g_ret_sts_success THEN
2208:
2209: l_api_message := 'Insert_PAC_eamBalAcct error';
2210: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2211: ||TO_CHAR(l_stmt_num)
2212: ||'): ', l_api_message);
2213: RAISE FND_API.g_exc_error;
2214:

Line 2254: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2250:
2251: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2252: l_api_message := 'CST_EAMCOST_PUB.Get_MaintCostCat() returned error';
2253: l_msg_data := l_api_message;
2254: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2255: l_api_name,
2256: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2257: || SUBSTRB (SQLERRM , 1 , 240));
2258: RAISE FND_API.g_exc_error;

Line 2280: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2276:
2277: IF l_eam_cost_element = 0 THEN
2278: l_api_message := 'Invalid cost element for the direct item';
2279: l_msg_data := l_api_message;
2280: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2281: l_api_name,
2282: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2283: || SUBSTRB (SQLERRM , 1 , 240));
2284: RAISE FND_API.g_exc_error;

Line 2322: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2318:
2319: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2320: l_api_message := 'insertupdate_PAC_eamperbal() returned error';
2321: l_msg_data := l_api_message;
2322: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2323: l_api_name,
2324: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2325: || SUBSTRB (SQLERRM , 1 , 240));
2326: RAISE FND_API.G_EXC_ERROR;

Line 2381: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('

2377:
2378: IF l_return_status <> FND_API.g_ret_sts_success THEN
2379:
2380: l_api_message := 'Insert_PAC_eamBalAcct error';
2381: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2382: ||TO_CHAR(l_stmt_num)
2383: ||'): ', l_api_message);
2384: RAISE FND_API.g_exc_error;
2385:

Line 2422: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2418:
2419: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2420: l_api_message := 'CST_EAMCOST_PUB.Get_MaintCostCat() returned error';
2421: l_msg_data := l_api_message;
2422: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2423: l_api_name,
2424: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2425: || SUBSTRB (SQLERRM , 1 , 240));
2426: RAISE FND_API.G_EXC_ERROR;

Line 2476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2472:
2473: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2474: l_api_message := 'insertupdate_PAC_eamperbal() returned error';
2475: l_msg_data := l_api_message;
2476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2477: l_api_name,
2478: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2479: || SUBSTRB (SQLERRM , 1 , 240));
2480: RAISE FND_API.G_EXC_ERROR;

Line 2536: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('

2532:
2533: IF l_return_status <> FND_API.g_ret_sts_success THEN
2534:
2535: l_api_message := 'Insert_PAC_eamBalAcct error';
2536: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2537: ||TO_CHAR(l_stmt_num)
2538: ||'): ', l_api_message);
2539: RAISE FND_API.g_exc_error;
2540:

Line 2585: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2581:
2582: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2583: l_api_message := 'CST_EAMCOST_PUB.Get_MaintCostCat() returned error';
2584: l_msg_data := l_api_message;
2585: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2586: l_api_name,
2587: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2588: || SUBSTRB (SQLERRM , 1 , 240));
2589: RAISE FND_API.G_EXC_ERROR;

Line 2641: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2637:
2638: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2639: l_api_message := 'insertupdate_PAC_eamperbal() returned error';
2640: l_msg_data := l_api_message;
2641: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2642: l_api_name,
2643: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2644: || SUBSTRB (SQLERRM , 1 , 240));
2645: RAISE FND_API.G_EXC_ERROR;

Line 2700: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('

2696:
2697: IF l_return_status <> FND_API.g_ret_sts_success THEN
2698:
2699: l_api_message := 'Insert_PAC_eamBalAcct error';
2700: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2701: ||TO_CHAR(l_stmt_num)
2702: ||'): ', l_api_message);
2703: RAISE FND_API.g_exc_error;
2704:

Line 2727: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2723: COMMIT WORK;
2724: END IF;
2725:
2726: -- Standard Call to get message count and if count = 1, get message info
2727: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2728: p_data => x_msg_data );
2729:
2730: -- Procedure level log message for exit point
2731: IF (l_pLog) THEN

Line 2754: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,

2750: l_msg_data);
2751: END IF;
2752:
2753: -- Get message count and data
2754: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
2755: p_data => x_msg_data);
2756:
2757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2758: ROLLBACK TO Compute_PAC_JobEstimates_PUB;

Line 2770: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,

2766: l_msg_data);
2767: END IF;
2768:
2769: -- Get message count and data
2770: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
2771: p_data => x_msg_data);
2772:
2773: WHEN OTHERS THEN
2774: ROLLBACK TO Compute_PAC_JobEstimates_PUB;

Line 2777: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2773: WHEN OTHERS THEN
2774: ROLLBACK TO Compute_PAC_JobEstimates_PUB;
2775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2776:
2777: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2778: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2779: l_api_name,
2780: '(' || TO_CHAR(l_stmt_num) || ') : '
2781: || SUBSTRB (SQLERRM , 1 , 240));

Line 2778: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2774: ROLLBACK TO Compute_PAC_JobEstimates_PUB;
2775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2776:
2777: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2778: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2779: l_api_name,
2780: '(' || TO_CHAR(l_stmt_num) || ') : '
2781: || SUBSTRB (SQLERRM , 1 , 240));
2782: END IF;

Line 2792: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,

2788: l_msg_data || SUBSTRB (SQLERRM , 1 , 240));
2789: END IF;
2790:
2791: -- Get message count and data
2792: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
2793: p_data => x_msg_data);
2794:
2795: END Compute_PAC_JobEstimates;
2796:

Line 2975: FND_MSG_PUB.initialize;

2971: END IF;
2972:
2973: -- Initialize message list if p_init_msg_list is set to TRUE
2974: IF FND_API.to_Boolean(p_init_msg_list) THEN
2975: FND_MSG_PUB.initialize;
2976: END IF;
2977:
2978: -- Initialize API return status to success
2979: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3242: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

3238:
3239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3240: l_api_message := 'insertupdate_PAC_assetperbal() returned error';
3241: l_msg_data := l_api_message;
3242: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3243: l_api_name,
3244: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
3245: || SUBSTRB (SQLERRM , 1 , 240));
3246: RAISE FND_API.G_EXC_ERROR;

Line 3255: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

3251: COMMIT WORK;
3252: END IF;
3253:
3254: -- Standard Call to get message count and if count = 1, get message info
3255: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3256: p_data => x_msg_data );
3257:
3258: -- Procedure level log message for exit point
3259: IF (l_pLog) THEN

Line 3281: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

3277: l_msg_data);
3278: END IF;
3279:
3280: -- Get message count and data
3281: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
3282: p_data => x_msg_data);
3283:
3284: WHEN FND_API.g_exc_unexpected_error THEN
3285: ROLLBACK TO InsertUpdate_PAC_eamPerBal_PUB;

Line 3296: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

3292: l_msg_data);
3293: END IF;
3294:
3295: -- Get message count and data
3296: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
3297: p_data => x_msg_data);
3298:
3299: WHEN OTHERS THEN
3300: ROLLBACK TO InsertUpdate_PAC_eamPerBal_PUB;

Line 3303: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3299: WHEN OTHERS THEN
3300: ROLLBACK TO InsertUpdate_PAC_eamPerBal_PUB;
3301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3302:
3303: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3304: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3305: l_api_name,
3306: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
3307: || SUBSTRB (SQLERRM , 1 , 240));

Line 3304: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

3300: ROLLBACK TO InsertUpdate_PAC_eamPerBal_PUB;
3301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3302:
3303: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3304: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3305: l_api_name,
3306: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
3307: || SUBSTRB (SQLERRM , 1 , 240));
3308: END IF;

Line 3318: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

3314: l_msg_data || SUBSTRB (SQLERRM , 1 , 240));
3315: END IF;
3316:
3317: -- Get message count and data
3318: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
3319: p_data => x_msg_data);
3320:
3321: END InsertUpdate_PAC_eamPerBal;
3322:

Line 3462: FND_MSG_PUB.initialize;

3458: END IF;
3459:
3460: -- Initialize message list if p_init_msg_list is set to TRUE
3461: IF FND_API.to_Boolean(p_init_msg_list) THEN
3462: FND_MSG_PUB.initialize;
3463: END IF;
3464:
3465: -- Initialize API return status to success
3466: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3596: FND_MSG_PUB.COUNT_AND_GET (p_count => x_msg_count,

3592: COMMIT WORK;
3593: END IF;
3594:
3595: -- Standard Call to get message count and if count = 1, get message info
3596: FND_MSG_PUB.COUNT_AND_GET (p_count => x_msg_count,
3597: p_data => x_msg_data );
3598:
3599: -- Procedure level log message for exit point
3600: IF (l_pLog) THEN

Line 3622: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,

3618: l_msg_data);
3619: END IF;
3620:
3621: -- Get message count and data
3622: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
3623: p_data => x_msg_data);
3624:
3625: WHEN FND_API.g_exc_unexpected_error THEN
3626: ROLLBACK TO InsertUpdate_PAC_astPerBal_PUB;

Line 3637: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,

3633: l_msg_data);
3634: END IF;
3635:
3636: -- Get message count and data
3637: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
3638: p_data => x_msg_data);
3639:
3640: WHEN OTHERS THEN
3641: ROLLBACK TO InsertUpdate_PAC_astPerBal_PUB;

Line 3644: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3640: WHEN OTHERS THEN
3641: ROLLBACK TO InsertUpdate_PAC_astPerBal_PUB;
3642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3643:
3644: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3645: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3646: l_api_name,
3647: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
3648: || SUBSTRB (SQLERRM , 1 , 240));

Line 3645: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

3641: ROLLBACK TO InsertUpdate_PAC_astPerBal_PUB;
3642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3643:
3644: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3645: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3646: l_api_name,
3647: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
3648: || SUBSTRB (SQLERRM , 1 , 240));
3649:

Line 3660: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,

3656: l_msg_data || SUBSTRB (SQLERRM , 1 , 240));
3657: END IF;
3658:
3659: -- Get message count and data
3660: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
3661: p_data => x_msg_data);
3662:
3663: END InsertUpdate_PAC_assetPerBal;
3664:

Line 3817: FND_MSG_PUB.initialize;

3813: END IF;
3814:
3815: -- Initialize message list if p_init_msg_list is set to TRUE
3816: IF FND_API.to_Boolean(p_init_msg_list) THEN
3817: FND_MSG_PUB.initialize;
3818: END IF;
3819:
3820: -- Initialize API return status to success
3821: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3849: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

3845: AND (l_period_set_name IS NULL OR l_period_name IS NULL)) THEN
3846:
3847: l_api_message := 'Cannot Find Period for the period_id ' || TO_CHAR(p_pac_period_id);
3848: l_msg_data := l_api_message;
3849: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
3850: l_api_name,
3851: '(' || TO_CHAR(l_stmt_num) ||'): ' || l_api_message);
3852: RAISE FND_API.G_EXC_ERROR;
3853: END IF;

Line 3874: FND_MSG_PUB.ADD;

3870: l_msg_data := l_api_message;
3871: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3872: FND_MESSAGE.set_token('TEXT', 'CST_PacEamCost_GRP.Compute_PAC_JobActuals('
3873: || to_char(l_stmt_num) || '): '|| l_api_message);
3874: FND_MSG_PUB.ADD;
3875: RAISE FND_API.G_EXC_ERROR;
3876: END IF;
3877:
3878: -- statement level logging

Line 3922: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

3918:
3919: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3920: l_api_message := 'CST_EAMCOST_PUB.Get_MaintCostCat returned error';
3921: l_msg_data := l_api_message;
3922: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
3923: l_api_name,
3924: '(' || TO_CHAR(l_stmt_num) ||'): ' || l_api_message);
3925: RAISE FND_API.G_EXC_ERROR;
3926: END IF;

Line 3951: FND_MSG_PUB.ADD;

3947: l_msg_data := l_api_message;
3948: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
3949: FND_MESSAGE.set_token('TEXT', 'CST_PacEamCost_GRP.Compute_PAC_JobActuals('
3950: || to_char(l_stmt_num) || '): ' || l_api_message);
3951: FND_MSG_PUB.ADD;
3952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3953: END IF;
3954:
3955: -- statement level logging

Line 3990: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

3986:
3987: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3988: l_api_message := 'CST_EAMCOST_PUB.Get_MaintCostCat returned error';
3989: l_msg_data := l_api_message;
3990: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
3991: l_api_name,
3992: '(' || TO_CHAR(l_stmt_num) ||'): ' || l_api_message);
3993: RAISE FND_API.G_EXC_ERROR;
3994: END IF;

Line 4007: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

4003:
4004: IF l_eam_cost_element = 0 THEN
4005: l_api_message := 'Get_eamCostElement returned error';
4006: l_msg_data := l_api_message;
4007: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
4008: l_api_name,
4009: '(' || TO_CHAR(l_stmt_num) ||'): ' || l_api_message);
4010: RAISE FND_API.G_EXC_ERROR;
4011: END IF;

Line 4058: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

4054:
4055: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4056: l_api_message := 'insertupdate_PAC_eamperbal() returned error';
4057: l_msg_data := l_api_message;
4058: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
4059: l_api_name,
4060: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
4061: || SUBSTRB (SQLERRM , 1 , 240));
4062: RAISE FND_API.G_EXC_ERROR;

Line 4079: FND_MSG_PUB.COUNT_AND_GET (p_count => x_msg_count,

4075: END IF;
4076: l_stmt_num := 40;
4077:
4078: -- Standard Call to get message count and if count = 1, get message info
4079: FND_MSG_PUB.COUNT_AND_GET (p_count => x_msg_count,
4080: p_data => x_msg_data );
4081:
4082: -- Procedure level log message for exit point
4083: IF (l_pLog) THEN

Line 4105: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,

4101: l_msg_data);
4102: END IF;
4103:
4104: -- Get message count and data
4105: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
4106: p_data => x_msg_data);
4107:
4108: WHEN FND_API.g_exc_unexpected_error THEN
4109: ROLLBACK TO Compute_PAC_JobActuals_PUB;

Line 4120: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,

4116: l_msg_data);
4117: END IF;
4118:
4119: -- Get message count and data
4120: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
4121: p_data => x_msg_data);
4122:
4123: WHEN OTHERS THEN
4124: ROLLBACK TO Compute_PAC_JobActuals_PUB;

Line 4127: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4123: WHEN OTHERS THEN
4124: ROLLBACK TO Compute_PAC_JobActuals_PUB;
4125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4126:
4127: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4128: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
4129: l_api_name,
4130: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
4131: || SUBSTRB (SQLERRM , 1 , 240));

Line 4128: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

4124: ROLLBACK TO Compute_PAC_JobActuals_PUB;
4125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4126:
4127: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4128: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
4129: l_api_name,
4130: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
4131: || SUBSTRB (SQLERRM , 1 , 240));
4132: END IF;

Line 4142: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,

4138: l_msg_data || SUBSTRB (SQLERRM , 1 , 240));
4139: END IF;
4140:
4141: -- Get message count and data
4142: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
4143: p_data => x_msg_data);
4144:
4145:
4146: END Compute_PAC_JobActuals;

Line 4302: FND_MSG_PUB.initialize;

4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4299: END IF;
4300: -- Initialize message list if p_init_msg_list is set to TRUE.
4301: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4302: FND_MSG_PUB.initialize;
4303: END IF;
4304:
4305: l_stmt_num := 10;
4306:

Line 4417: FND_MSG_PUB.Count_And_Get

4413: );
4414: END IF;
4415:
4416: -- Standard call to get message count and if count is 1, get message info.
4417: FND_MSG_PUB.Count_And_Get
4418: ( p_count => x_msg_count ,
4419: p_data => x_msg_data
4420: );
4421:

Line 4436: FND_MSG_PUB.Count_And_Get

4432: );
4433: END IF;
4434:
4435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4436: FND_MSG_PUB.Count_And_Get
4437: ( p_count => x_msg_count ,
4438: p_data => x_msg_data
4439: );
4440: WHEN OTHERS THEN

Line 4452: IF FND_MSG_PUB.Check_Msg_Level

4448: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240)
4449: );
4450: END IF;
4451:
4452: IF FND_MSG_PUB.Check_Msg_Level
4453: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4454: THEN
4455: FND_MSG_PUB.Add_Exc_Msg
4456: ( 'CST_eamCost_PUB' ,

Line 4453: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4449: );
4450: END IF;
4451:
4452: IF FND_MSG_PUB.Check_Msg_Level
4453: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4454: THEN
4455: FND_MSG_PUB.Add_Exc_Msg
4456: ( 'CST_eamCost_PUB' ,
4457: l_api_name

Line 4455: FND_MSG_PUB.Add_Exc_Msg

4451:
4452: IF FND_MSG_PUB.Check_Msg_Level
4453: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4454: THEN
4455: FND_MSG_PUB.Add_Exc_Msg
4456: ( 'CST_eamCost_PUB' ,
4457: l_api_name
4458: );
4459: END IF;

Line 4460: FND_MSG_PUB.Count_And_Get

4456: ( 'CST_eamCost_PUB' ,
4457: l_api_name
4458: );
4459: END IF;
4460: FND_MSG_PUB.Count_And_Get
4461: ( p_count => x_msg_count ,
4462: p_data => x_msg_data
4463: );
4464: END Insert_PAC_eamBalAcct;

Line 4534: FND_MSG_PUB.initialize;

4530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4531: END IF;
4532: -- Initialize message list if p_init_msg_list is set to TRUE.
4533: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4534: FND_MSG_PUB.initialize;
4535: END IF;
4536:
4537: if( l_pLog ) then
4538: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 4573: FND_MSG_PUB.Count_And_Get

4569: );
4570: END IF;
4571:
4572: -- Standard call to get message count and if count is 1, get message info.
4573: FND_MSG_PUB.Count_And_Get
4574: ( p_count => x_msg_count ,
4575: p_data => x_msg_data
4576: );
4577:

Line 4592: FND_MSG_PUB.Count_And_Get

4588: l_full_name ||'('|| l_stmt_num ||') :' ||
4589: SUBSTRB (SQLERRM , 1 , 240));
4590: END IF;
4591:
4592: FND_MSG_PUB.Count_And_Get
4593: ( p_count => x_msg_count ,
4594: p_data => x_msg_data
4595: );
4596: WHEN OTHERS THEN

Line 4608: IF FND_MSG_PUB.Check_Msg_Level

4604: l_full_name ||'('|| l_stmt_num ||') :' ||
4605: SUBSTRB (SQLERRM , 1 , 240));
4606: END IF;
4607:
4608: IF FND_MSG_PUB.Check_Msg_Level
4609: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4610: THEN
4611: FND_MSG_PUB.Add_Exc_Msg
4612: ( 'CST_eamCost_PUB' ,

Line 4609: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4605: SUBSTRB (SQLERRM , 1 , 240));
4606: END IF;
4607:
4608: IF FND_MSG_PUB.Check_Msg_Level
4609: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4610: THEN
4611: FND_MSG_PUB.Add_Exc_Msg
4612: ( 'CST_eamCost_PUB' ,
4613: l_api_name

Line 4611: FND_MSG_PUB.Add_Exc_Msg

4607:
4608: IF FND_MSG_PUB.Check_Msg_Level
4609: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4610: THEN
4611: FND_MSG_PUB.Add_Exc_Msg
4612: ( 'CST_eamCost_PUB' ,
4613: l_api_name
4614: );
4615: END IF;

Line 4616: FND_MSG_PUB.Count_And_Get

4612: ( 'CST_eamCost_PUB' ,
4613: l_api_name
4614: );
4615: END IF;
4616: FND_MSG_PUB.Count_And_Get
4617: ( p_count => x_msg_count ,
4618: p_data => x_msg_data
4619: );
4620: END Delete_PAC_eamBalAcct;