DBA Data[Home] [Help]

APPS.IGC_CC_REVAL_FIX_PROCESS_PKG dependencies on FND_API

Line 257: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

253: p_filename_val => NULL,
254: x_Return_Status => l_Return_Status
255: );
256:
257: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
258: raise FND_API.G_EXC_ERROR;
259: END IF;
260:
261: RETURN;

Line 258: raise FND_API.G_EXC_ERROR;

254: x_Return_Status => l_Return_Status
255: );
256:
257: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
258: raise FND_API.G_EXC_ERROR;
259: END IF;
260:
261: RETURN;
262:

Line 268: WHEN FND_API.G_EXC_ERROR THEN

264: -- Exception handler section for the Output_Debug procedure.
265: -- --------------------------------------------------------------------
266: EXCEPTION
267:
268: WHEN FND_API.G_EXC_ERROR THEN
269: RETURN;
270:
271: WHEN OTHERS THEN
272: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

Line 780: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

776: l_new_cc_det_pf_func_amt igc_cc_det_pf.cc_det_pf_func_amt%TYPE;
777: l_new_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
778:
779: l_api_version CONSTANT NUMBER := 1.0;
780: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
781: l_commit VARCHAR2(1) := FND_API.G_FALSE;
782: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
783: l_return_status VARCHAR2(1);
784: l_msg_count NUMBER;

Line 781: l_commit VARCHAR2(1) := FND_API.G_FALSE;

777: l_new_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
778:
779: l_api_version CONSTANT NUMBER := 1.0;
780: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
781: l_commit VARCHAR2(1) := FND_API.G_FALSE;
782: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
783: l_return_status VARCHAR2(1);
784: l_msg_count NUMBER;
785: l_msg_data VARCHAR2(2000);

Line 782: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

778:
779: l_api_version CONSTANT NUMBER := 1.0;
780: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
781: l_commit VARCHAR2(1) := FND_API.G_FALSE;
782: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
783: l_return_status VARCHAR2(1);
784: l_msg_count NUMBER;
785: l_msg_data VARCHAR2(2000);
786: G_FLAG VARCHAR2(1);

Line 841: l_return_status := FND_API.G_RET_STS_SUCCESS;

837: END IF;
838:
839:
840: /* Update Header History */
841: l_return_status := FND_API.G_RET_STS_SUCCESS;
842:
843: IGC_CC_HEADER_HISTORY_PKG.Insert_Row(
844: l_api_version,
845: l_init_msg_list,

Line 908: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

904: l_cc_headers_rec.CONTEXT,
905: l_cc_headers_rec.CC_GUARANTEE_FLAG,
906: G_FLAG);
907:
908: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
909: THEN
910:
911: l_EXCEPTION := NULL;
912: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADER_HST_INSERT');

Line 987: l_return_status := FND_API.G_RET_STS_SUCCESS;

983: THEN
984:
985: /* Update PF Line History */
986:
987: l_return_status := FND_API.G_RET_STS_SUCCESS;
988:
989: IGC_CC_DET_PF_HISTORY_PKG.Insert_Row(
990: l_api_version,
991: l_init_msg_list,

Line 1036: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1032: l_cc_pmt_fcst_rec.Attribute15,
1033: l_cc_pmt_fcst_rec.Context,
1034: G_FLAG );
1035:
1036: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1037: THEN
1038:
1039: l_EXCEPTION := NULL;
1040: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_HST_INSERT');

Line 1138: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1134: l_cc_pmt_fcst_rec.Context,
1135: G_FLAG );
1136:
1137:
1138: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1139: THEN
1140:
1141: l_EXCEPTION := NULL;
1142: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_UPDATE');

Line 1163: l_return_status := FND_API.G_RET_STS_SUCCESS;

1159:
1160: IF (l_new_cc_acct_func_amt <> 0)
1161: THEN
1162: /* Update Account Line History*/
1163: l_return_status := FND_API.G_RET_STS_SUCCESS;
1164:
1165: IGC_CC_ACCT_LINE_HISTORY_PKG.Insert_Row(
1166: l_api_version ,
1167: l_init_msg_list,

Line 1225: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1221: G_FLAG,
1222: l_cc_acct_lines_rec.TAX_CLASSIF_CODE /* r12 EBtax uptake for CC */
1223: );
1224:
1225: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1226: THEN
1227:
1228: l_EXCEPTION := NULL;
1229: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINE_HST_INSERT');

Line 1321: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1317: l_cc_acct_lines_rec.TAX_CLASSIF_CODE /* Bug 6472296 for r12 EBtax uptake for CC */
1318: );
1319:
1320:
1321: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1322: THEN
1323:
1324: l_EXCEPTION := NULL;
1325: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINES_UPDATE');

Line 1443: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1439: l_cc_headers_rec.CONTEXT,
1440: l_cc_headers_rec.CC_Guarantee_Flag,
1441: G_FLAG);
1442:
1443: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1444: THEN
1445:
1446: l_EXCEPTION := NULL;
1447: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADERS_UPDATE');

Line 1477: l_return_status := FND_API.G_RET_STS_SUCCESS;

1473: /* Changed l_cc_headers_rec.cc_apprvl_status to l_approval_status to fix bug 1632984 */
1474: ( ( (l_cc_headers_rec.cc_state = 'CM') AND (l_approval_status = 'AP') ) OR
1475: (l_cc_headers_rec.cc_state = 'CT') )
1476: THEN
1477: l_return_status := FND_API.G_RET_STS_SUCCESS;
1478:
1479: IGC_CC_PO_INTERFACE_PKG.Convert_CC_TO_PO(1.0,
1480: FND_API.G_FALSE,
1481: FND_API.G_TRUE,

Line 1480: FND_API.G_FALSE,

1476: THEN
1477: l_return_status := FND_API.G_RET_STS_SUCCESS;
1478:
1479: IGC_CC_PO_INTERFACE_PKG.Convert_CC_TO_PO(1.0,
1480: FND_API.G_FALSE,
1481: FND_API.G_TRUE,
1482: FND_API.G_VALID_LEVEL_NONE,
1483: l_return_status,
1484: l_msg_count,

Line 1481: FND_API.G_TRUE,

1477: l_return_status := FND_API.G_RET_STS_SUCCESS;
1478:
1479: IGC_CC_PO_INTERFACE_PKG.Convert_CC_TO_PO(1.0,
1480: FND_API.G_FALSE,
1481: FND_API.G_TRUE,
1482: FND_API.G_VALID_LEVEL_NONE,
1483: l_return_status,
1484: l_msg_count,
1485: l_msg_data,

Line 1482: FND_API.G_VALID_LEVEL_NONE,

1478:
1479: IGC_CC_PO_INTERFACE_PKG.Convert_CC_TO_PO(1.0,
1480: FND_API.G_FALSE,
1481: FND_API.G_TRUE,
1482: FND_API.G_VALID_LEVEL_NONE,
1483: l_return_status,
1484: l_msg_count,
1485: l_msg_data,
1486: l_cc_headers_rec.cc_header_id);

Line 1488: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1484: l_msg_count,
1485: l_msg_data,
1486: l_cc_headers_rec.cc_header_id);
1487:
1488: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1489: THEN
1490: RETURN 'F';
1491: END IF;
1492: END IF;

Line 1521: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1517: l_Last_Update_Login,
1518: Sysdate,
1519: l_Created_By);
1520:
1521: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1522: THEN
1523:
1524: l_EXCEPTION := NULL;
1525: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACTION_HST_INSERT');

Line 1928: l_debug := FND_API.G_TRUE;

1924: --
1925: /*
1926: l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1927: IF (l_debug = 'Y') THEN
1928: l_debug := FND_API.G_TRUE;
1929: ELSE
1930: l_debug := FND_API.G_FALSE;
1931: END IF;
1932: IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

Line 1930: l_debug := FND_API.G_FALSE;

1926: l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1927: IF (l_debug = 'Y') THEN
1928: l_debug := FND_API.G_TRUE;
1929: ELSE
1930: l_debug := FND_API.G_FALSE;
1931: END IF;
1932: IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1933: */
1934:

Line 1932: IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

1928: l_debug := FND_API.G_TRUE;
1929: ELSE
1930: l_debug := FND_API.G_FALSE;
1931: END IF;
1932: IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1933: */
1934:
1935: /* Get Budgetary Control information */
1936:

Line 2060: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

2056: l_error_text := '';
2057:
2058: FOR l_cur IN 1..l_msg_count
2059: LOOP
2060: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
2061: -- fnd_file.put_line (FND_FILE.LOG,
2062: -- l_error_text);
2063: -- bug 3199488 start block
2064: IF (l_state_level >= l_debug_level) THEN

Line 2154: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

2150:
2151: IF (l_msg_count > 0) THEN
2152: l_error_text := '';
2153: FOR l_cur IN 1..l_msg_count LOOP
2154: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
2155: -- fnd_file.put_line (FND_FILE.LOG,
2156: -- l_error_text);
2157: -- bug 3199488 start block
2158: IF (l_state_level >= l_debug_level) THEN

Line 3453: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

3449:
3450: IF (l_msg_count > 0) THEN
3451: l_error_text := '';
3452: FOR l_cur IN 1..l_msg_count LOOP
3453: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
3454: -- fnd_file.put_line (FND_FILE.LOG,
3455: -- l_error_text);
3456: -- bug 3199488 start block
3457: IF (l_state_level >= l_debug_level) THEN

Line 3484: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

3480: IF (l_msg_count > 0) THEN
3481:
3482: l_error_text := '';
3483: FOR l_cur IN 1..l_msg_count LOOP
3484: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
3485: -- fnd_file.put_line (FND_FILE.LOG,
3486: -- l_error_text);
3487: -- bug 3199488 start block
3488: IF (l_state_level >= l_debug_level) THEN

Line 3527: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

3523: IF (l_msg_count > 0) THEN
3524:
3525: l_error_text := '';
3526: FOR l_cur IN 1..l_msg_count LOOP
3527: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
3528: -- fnd_file.put_line (FND_FILE.LOG,
3529: -- l_error_text);
3530: -- bug 3199488 start block
3531: IF (l_state_level >= l_debug_level) THEN