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 3243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

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

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

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

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

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

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

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

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

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

Line 3305: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

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

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

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

Line 3463: FND_MSG_PUB.initialize;

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

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

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

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

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

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

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

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

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

Line 3646: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

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

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

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

Line 3818: FND_MSG_PUB.initialize;

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

Line 3850: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

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

Line 3875: FND_MSG_PUB.ADD;

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

Line 3923: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

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

Line 3952: FND_MSG_PUB.ADD;

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

Line 3991: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

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

Line 4008: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

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

Line 4059: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

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

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

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

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

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

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

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

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

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

Line 4129: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

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

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

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

Line 4303: FND_MSG_PUB.initialize;

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

Line 4418: FND_MSG_PUB.Count_And_Get

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

Line 4437: FND_MSG_PUB.Count_And_Get

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

Line 4453: IF FND_MSG_PUB.Check_Msg_Level

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

Line 4454: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 4456: FND_MSG_PUB.Add_Exc_Msg

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

Line 4461: FND_MSG_PUB.Count_And_Get

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

Line 4535: FND_MSG_PUB.initialize;

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

Line 4574: FND_MSG_PUB.Count_And_Get

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

Line 4593: FND_MSG_PUB.Count_And_Get

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

Line 4609: IF FND_MSG_PUB.Check_Msg_Level

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

Line 4610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 4612: FND_MSG_PUB.Add_Exc_Msg

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

Line 4617: FND_MSG_PUB.Count_And_Get

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