DBA Data[Home] [Help]

APPS.IGC_CC_YEP_PROCESS_PKG dependencies on FND_API

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

67: V14 C14%ROWTYPE;
68: V15 C15%ROWTYPE;
69: V16 C16%ROWTYPE;
70: l_api_version CONSTANT NUMBER := 1.0;
71: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
72: l_commit VARCHAR2(1) := FND_API.G_FALSE;
73: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
74: l_return_status VARCHAR2(1);
75: l_msg_count NUMBER;

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

68: V15 C15%ROWTYPE;
69: V16 C16%ROWTYPE;
70: l_api_version CONSTANT NUMBER := 1.0;
71: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
72: l_commit VARCHAR2(1) := FND_API.G_FALSE;
73: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
74: l_return_status VARCHAR2(1);
75: l_msg_count NUMBER;
76: l_msg_data VARCHAR2(2000);

Line 73: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

69: V16 C16%ROWTYPE;
70: l_api_version CONSTANT NUMBER := 1.0;
71: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
72: l_commit VARCHAR2(1) := FND_API.G_FALSE;
73: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
74: l_return_status VARCHAR2(1);
75: l_msg_count NUMBER;
76: l_msg_data VARCHAR2(2000);
77: G_FLAG VARCHAR2(1);

Line 172: l_return_status := FND_API.G_RET_STS_SUCCESS;

168:
169: END IF; /* Provisional CC */
170:
171:
172: l_return_status := FND_API.G_RET_STS_SUCCESS;
173:
174: IGC_CC_HEADER_HISTORY_PKG.Insert_Row(
175: l_api_version,
176: l_init_msg_list,

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

233: V14.CONTEXT,
234: V14.CC_GUARANTEE_FLAG,
235: G_FLAG);
236:
237: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
238: THEN
239: ROLLBACK TO S1;
240: l_EXCEPTION := NULL;
241: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADER_HST_INSERT');

Line 280: l_return_status := FND_API.G_RET_STS_SUCCESS;

276: EXIT WHEN C15%NOTFOUND;
277:
278: /* Update Account Line History*/
279:
280: l_return_status := FND_API.G_RET_STS_SUCCESS;
281:
282: IGC_CC_ACCT_LINE_HISTORY_PKG.Insert_Row(
283: l_api_version ,
284: l_init_msg_list,

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

338: G_FLAG,
339: V15.tax_classif_code--Bug 6472296 EB Tax uptake
340: );
341:
342: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
343: THEN
344: ROLLBACK TO S1;
345: l_EXCEPTION := NULL;
346: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINE_HST_INSERT');

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

452: V15.tax_classif_code -- Bug 6472296 EB Tax uptake
453: );
454:
455:
456: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
457: THEN
458: ROLLBACK TO S1;
459: l_EXCEPTION := NULL;
460: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACT_LINES_UPDATE');

Line 499: l_return_status := FND_API.G_RET_STS_SUCCESS;

495: FETCH C16 INTO V16;
496:
497: EXIT WHEN C16%NOTFOUND;
498:
499: l_return_status := FND_API.G_RET_STS_SUCCESS;
500:
501: -- 2251118, Check that the line is not fully billed
502: -- Bidisha S, 12 Mar 2002
503: SELECT cc_det_pf_func_amt,

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

559: V16.Attribute14,
560: V16.Attribute15,
561: V16.Context,
562: G_FLAG );
563: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
564: THEN
565: ROLLBACK TO S1;
566: l_EXCEPTION := NULL;
567: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_HST_INSERT');

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

660: V16.Context,
661: G_FLAG );
662:
663:
664: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
665: THEN
666: ROLLBACK TO S1;
667: l_EXCEPTION := NULL;
668: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_DET_PF_UPDATE');

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

785: V14.CONTEXT,
786: V14.CC_GUARANTEE_FLAG,
787: G_FLAG);
788:
789: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
790: THEN
791: ROLLBACK TO S1;
792: l_EXCEPTION := NULL;
793: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_HEADERS_UPDATE');

Line 827: l_init_msg_list := FND_API.G_FALSE;

823:
824:
825: /* Insert into Action History */
826:
827: l_init_msg_list := FND_API.G_FALSE;
828: l_commit := FND_API.G_FALSE;
829: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
830:
831: l_return_status := '';

Line 828: l_commit := FND_API.G_FALSE;

824:
825: /* Insert into Action History */
826:
827: l_init_msg_list := FND_API.G_FALSE;
828: l_commit := FND_API.G_FALSE;
829: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
830:
831: l_return_status := '';
832:

Line 829: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

825: /* Insert into Action History */
826:
827: l_init_msg_list := FND_API.G_FALSE;
828: l_commit := FND_API.G_FALSE;
829: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
830:
831: l_return_status := '';
832:
833: /* added following code to remove hard coded message reference */

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

858: l_Last_Update_Login,
859: Sysdate,
860: l_Created_By);
861:
862: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
863: THEN
864: ROLLBACK TO S1;
865: l_EXCEPTION := NULL;
866: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_ACTION_HST_INSERT');

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

1090: l_APPROVED_FLAG PO_HEADERS_ALL.APPROVED_FLAG%TYPE;
1091: l_HEADER_ID IGC_CC_HEADERS.CC_HEADER_ID%TYPE;
1092: RELEASE_YEAR_END_COUNTER NUMBER;
1093: l_api_version CONSTANT NUMBER := 1.0;
1094: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1095: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1096: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1097: l_return_status VARCHAR2(1);
1098: l_msg_count NUMBER;

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

1091: l_HEADER_ID IGC_CC_HEADERS.CC_HEADER_ID%TYPE;
1092: RELEASE_YEAR_END_COUNTER NUMBER;
1093: l_api_version CONSTANT NUMBER := 1.0;
1094: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1095: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1096: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1097: l_return_status VARCHAR2(1);
1098: l_msg_count NUMBER;
1099: l_msg_data VARCHAR2(12000);

Line 1096: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

1092: RELEASE_YEAR_END_COUNTER NUMBER;
1093: l_api_version CONSTANT NUMBER := 1.0;
1094: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1095: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1096: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1097: l_return_status VARCHAR2(1);
1098: l_msg_count NUMBER;
1099: l_msg_data VARCHAR2(12000);
1100: l_usr_msg igc_cc_process_exceptions.exception_reason%TYPE;

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

1307: THEN
1308: l_error_text := '';
1309: FOR l_cur IN 1..l_msg_count
1310: LOOP
1311: l_error_text := l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
1312:
1313: IF (g_excep_level >= g_debug_level) then
1314: fnd_log.string(g_excep_level,l_full_path,l_error_text);
1315: END IF;

Line 2380: FND_API.G_FALSE,

2376: B.CC_HEADER_ID = V2.CC_HEADER_ID );
2377:
2378: IGC_CC_PO_INTERFACE_PKG.convert_cc_to_po
2379: ( 1.0,
2380: FND_API.G_FALSE,
2381: FND_API.G_FALSE,
2382: FND_API.G_VALID_LEVEL_FULL,
2383: l_return_status,
2384: l_msg_count,

Line 2381: FND_API.G_FALSE,

2377:
2378: IGC_CC_PO_INTERFACE_PKG.convert_cc_to_po
2379: ( 1.0,
2380: FND_API.G_FALSE,
2381: FND_API.G_FALSE,
2382: FND_API.G_VALID_LEVEL_FULL,
2383: l_return_status,
2384: l_msg_count,
2385: l_msg_data,

Line 2382: FND_API.G_VALID_LEVEL_FULL,

2378: IGC_CC_PO_INTERFACE_PKG.convert_cc_to_po
2379: ( 1.0,
2380: FND_API.G_FALSE,
2381: FND_API.G_FALSE,
2382: FND_API.G_VALID_LEVEL_FULL,
2383: l_return_status,
2384: l_msg_count,
2385: l_msg_data,
2386: V2.CC_HEADER_ID);

Line 2557: FND_API.G_FALSE,

2553: B.CC_HEADER_ID = V11.CC_HEADER_ID );
2554:
2555: IGC_CC_PO_INTERFACE_PKG.convert_cc_to_po
2556: ( 1.0,
2557: FND_API.G_FALSE,
2558: FND_API.G_FALSE,
2559: FND_API.G_VALID_LEVEL_FULL,
2560: l_return_status,
2561: l_msg_count,

Line 2558: FND_API.G_FALSE,

2554:
2555: IGC_CC_PO_INTERFACE_PKG.convert_cc_to_po
2556: ( 1.0,
2557: FND_API.G_FALSE,
2558: FND_API.G_FALSE,
2559: FND_API.G_VALID_LEVEL_FULL,
2560: l_return_status,
2561: l_msg_count,
2562: l_msg_data,

Line 2559: FND_API.G_VALID_LEVEL_FULL,

2555: IGC_CC_PO_INTERFACE_PKG.convert_cc_to_po
2556: ( 1.0,
2557: FND_API.G_FALSE,
2558: FND_API.G_FALSE,
2559: FND_API.G_VALID_LEVEL_FULL,
2560: l_return_status,
2561: l_msg_count,
2562: l_msg_data,
2563: V11.CC_HEADER_ID);

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

2883:
2884: IF (l_msg_count > 0) THEN
2885: l_error_text := '';
2886: FOR l_cur IN 1..l_msg_count LOOP
2887: l_error_text := l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
2888:
2889: IF (g_excep_level >= g_debug_level) then
2890: fnd_log.string(g_excep_level,l_full_path,l_error_text);
2891: END IF;

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

2907: IF (l_msg_count > 0) THEN
2908:
2909: l_error_text := '';
2910: FOR l_cur IN 1..l_msg_count LOOP
2911: l_error_text := l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
2912:
2913: IF (g_excep_level >= g_debug_level) then
2914:
2915: fnd_log.string(g_excep_level,l_full_path,l_error_text);