DBA Data[Home] [Help]

APPS.IGC_CC_REVALUE_PROCESS_PKG dependencies on FND_API

Line 624: l_init_msg_list := FND_API.G_FALSE;

620: BEGIN
621:
622: --GSCC Warnings Fixed
623:
624: l_init_msg_list := FND_API.G_FALSE;
625: l_commit := FND_API.G_FALSE;
626: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
627: l_Last_Updated_By := FND_GLOBAL.USER_ID;
628: l_Last_Update_Login := FND_GLOBAL.LOGIN_ID;

Line 625: l_commit := FND_API.G_FALSE;

621:
622: --GSCC Warnings Fixed
623:
624: l_init_msg_list := FND_API.G_FALSE;
625: l_commit := FND_API.G_FALSE;
626: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
627: l_Last_Updated_By := FND_GLOBAL.USER_ID;
628: l_Last_Update_Login := FND_GLOBAL.LOGIN_ID;
629: l_Created_By := FND_GLOBAL.USER_ID;

Line 626: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

622: --GSCC Warnings Fixed
623:
624: l_init_msg_list := FND_API.G_FALSE;
625: l_commit := FND_API.G_FALSE;
626: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
627: l_Last_Updated_By := FND_GLOBAL.USER_ID;
628: l_Last_Update_Login := FND_GLOBAL.LOGIN_ID;
629: l_Created_By := FND_GLOBAL.USER_ID;
630:

Line 660: l_return_status := FND_API.G_RET_STS_SUCCESS;

656: THEN
657:
658:
659: /* Update Header History */
660: l_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: IGC_CC_HEADER_HISTORY_PKG.Insert_Row(
663: l_api_version,
664: l_init_msg_list,

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

723: -- bug 2043221 ssmales - added Guarantee Flag argument in line below
724: l_cc_headers_rec.CC_GUARANTEE_FLAG,
725: G_FLAG);
726:
727: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
728: THEN
729:
730: l_EXCEPTION := NULL;
731: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADER_HST_INSERT');

Line 759: l_return_status := FND_API.G_RET_STS_SUCCESS;

755: FETCH c_acct_lines INTO l_cc_acct_lines_rec;
756: EXIT WHEN c_acct_lines%NOTFOUND;
757:
758: /* Update Account Line History*/
759: l_return_status := FND_API.G_RET_STS_SUCCESS;
760:
761: IGC_CC_ACCT_LINE_HISTORY_PKG.Insert_Row(
762: l_api_version ,
763: l_init_msg_list,

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

818: G_FLAG,
819: l_cc_acct_lines_rec.tax_classif_code -- added for Bug 6472296 Ebtax uptake for cc
820: );
821:
822: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
823: THEN
824: l_EXCEPTION := NULL;
825: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINE_HST_INSERT');
826: l_EXCEPTION := FND_MESSAGE.GET;

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

938: G_FLAG,
939: l_cc_acct_lines_rec.tax_classif_code);
940:
941:
942: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
943: THEN
944: l_EXCEPTION := NULL;
945: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINES_UPDATE');
946: l_EXCEPTION := FND_MESSAGE.GET;

Line 974: l_return_status := FND_API.G_RET_STS_SUCCESS;

970: EXIT WHEN c_pf_lines%NOTFOUND;
971:
972: /* Update PF Line History */
973:
974: l_return_status := FND_API.G_RET_STS_SUCCESS;
975:
976: IGC_CC_DET_PF_HISTORY_PKG.Insert_Row(
977: l_api_version,
978: l_init_msg_list,

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

1019: l_cc_pmt_fcst_rec.Attribute15,
1020: l_cc_pmt_fcst_rec.Context,
1021: G_FLAG );
1022:
1023: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1024: THEN
1025:
1026: l_EXCEPTION := NULL;
1027: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_HST_INSERT');

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

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

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

1278: l_cc_headers_rec.CONTEXT,
1279: l_cc_headers_rec.CC_GUARANTEE_FLAG,
1280: G_FLAG);
1281:
1282: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1283: THEN
1284:
1285: l_EXCEPTION := NULL;
1286: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADERS_UPDATE');

Line 1325: l_return_status := FND_API.G_RET_STS_SUCCESS;

1321: /* Changed l_cc_headers_rec.cc_apprvl_status to l_approval_status in the following line to fix bug 1613811 */
1322: ( ( (l_cc_headers_rec.cc_state = 'CM') AND (l_approval_status = 'AP') ) OR
1323: (l_cc_headers_rec.cc_state = 'CT') )
1324: THEN
1325: l_return_status := FND_API.G_RET_STS_SUCCESS;
1326:
1327: IGC_CC_PO_INTERFACE_PKG.Convert_CC_TO_PO(1.0,
1328: FND_API.G_FALSE,
1329: FND_API.G_TRUE,

Line 1328: FND_API.G_FALSE,

1324: THEN
1325: l_return_status := FND_API.G_RET_STS_SUCCESS;
1326:
1327: IGC_CC_PO_INTERFACE_PKG.Convert_CC_TO_PO(1.0,
1328: FND_API.G_FALSE,
1329: FND_API.G_TRUE,
1330: FND_API.G_VALID_LEVEL_NONE,
1331: l_return_status,
1332: l_msg_count,

Line 1329: FND_API.G_TRUE,

1325: l_return_status := FND_API.G_RET_STS_SUCCESS;
1326:
1327: IGC_CC_PO_INTERFACE_PKG.Convert_CC_TO_PO(1.0,
1328: FND_API.G_FALSE,
1329: FND_API.G_TRUE,
1330: FND_API.G_VALID_LEVEL_NONE,
1331: l_return_status,
1332: l_msg_count,
1333: l_msg_data,

Line 1330: FND_API.G_VALID_LEVEL_NONE,

1326:
1327: IGC_CC_PO_INTERFACE_PKG.Convert_CC_TO_PO(1.0,
1328: FND_API.G_FALSE,
1329: FND_API.G_TRUE,
1330: FND_API.G_VALID_LEVEL_NONE,
1331: l_return_status,
1332: l_msg_count,
1333: l_msg_data,
1334: l_cc_headers_rec.cc_header_id);

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

1332: l_msg_count,
1333: l_msg_data,
1334: l_cc_headers_rec.cc_header_id);
1335:
1336: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1337: THEN
1338: -- IF l_debug_mode = 'Y' THEN
1339: -- Output_Debug (' IGCCREPB -- Reval Update Ends 3 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
1340: -- END IF;

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

1380: l_Last_Update_Login,
1381: Sysdate,
1382: l_Created_By);
1383:
1384: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1385: THEN
1386:
1387: l_EXCEPTION := NULL;
1388: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACTION_HST_INSERT');

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

1478: p_filename_val => NULL,
1479: x_Return_Status => l_Return_Status
1480: );
1481:
1482: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1483: raise FND_API.G_EXC_ERROR;
1484: END IF;
1485:
1486: RETURN;

Line 1483: raise FND_API.G_EXC_ERROR;

1479: x_Return_Status => l_Return_Status
1480: );
1481:
1482: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1483: raise FND_API.G_EXC_ERROR;
1484: END IF;
1485:
1486: RETURN;
1487:

Line 1493: WHEN FND_API.G_EXC_ERROR THEN

1489: -- Exception handler section for the Output_Debug procedure.
1490: -- --------------------------------------------------------------------
1491: EXCEPTION
1492:
1493: WHEN FND_API.G_EXC_ERROR THEN
1494: RETURN;
1495:
1496: WHEN OTHERS THEN
1497: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

Line 1962: -- l_debug := FND_API.G_TRUE;

1958: -- Setup debug information based upon profile setup options.
1959: --
1960: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1961: -- IF (l_debug = 'Y') THEN
1962: -- l_debug := FND_API.G_TRUE;
1963: -- ELSE
1964: -- l_debug := FND_API.G_FALSE;
1965: -- END IF;
1966: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

Line 1964: -- l_debug := FND_API.G_FALSE;

1960: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1961: -- IF (l_debug = 'Y') THEN
1962: -- l_debug := FND_API.G_TRUE;
1963: -- ELSE
1964: -- l_debug := FND_API.G_FALSE;
1965: -- END IF;
1966: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1967:
1968: -- IF l_debug_mode = 'Y' THEN

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

1962: -- l_debug := FND_API.G_TRUE;
1963: -- ELSE
1964: -- l_debug := FND_API.G_FALSE;
1965: -- END IF;
1966: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1967:
1968: -- IF l_debug_mode = 'Y' THEN
1969: -- Output_Debug (' IGCCREPB -- ************ Starting Revalue CC '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1970: -- END IF;

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

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

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

2271:
2272: IF (l_msg_count > 0) THEN
2273: l_error_text := '';
2274: FOR l_cur IN 1..l_msg_count LOOP
2275: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
2276: -- fnd_file.put_line (FND_FILE.LOG,
2277: -- l_error_text);
2278: -- bug 3199488 start block
2279: IF (l_state_level >= l_debug_level) THEN

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

4957:
4958: IF (l_msg_count > 0) THEN
4959: l_error_text := '';
4960: FOR l_cur IN 1..l_msg_count LOOP
4961: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
4962: -- fnd_file.put_line (FND_FILE.LOG,
4963: -- l_error_text);
4964: -- bug 3199488 start block
4965: IF (l_state_level >= l_debug_level) THEN

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

4988: IF (l_msg_count > 0) THEN
4989:
4990: l_error_text := '';
4991: FOR l_cur IN 1..l_msg_count LOOP
4992: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
4993: -- fnd_file.put_line (FND_FILE.LOG,
4994: -- l_error_text);
4995: -- bug 3199488 start block
4996: IF (l_state_level >= l_debug_level) THEN

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

5030: IF (l_msg_count > 0) THEN
5031:
5032: l_error_text := '';
5033: FOR l_cur IN 1..l_msg_count LOOP
5034: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
5035: -- fnd_file.put_line (FND_FILE.LOG,
5036: -- l_error_text);
5037: -- bug 3199488 start block
5038: IF (l_state_level >= l_debug_level) THEN