DBA Data[Home] [Help]

APPS.IEX_DUNNING_PVT dependencies on STANDARD

Line 2037: -- Standard call to get message count and IF count is 1, get message info.

2033: END IF;
2034: CLOSE C_GET_Del;
2035: END IF;
2036:
2037: -- Standard call to get message count and IF count is 1, get message info.
2038: FND_MSG_PUB.Count_And_Get
2039: ( p_count => x_msg_count,
2040: p_data => x_msg_data );
2041:

Line 2064: -- Standard Start of API savepoint

2060: l_AG_DN_XREF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE ;
2061: errmsg VARCHAR2(32767);
2062:
2063: BEGIN
2064: -- Standard Start of API savepoint
2065: SAVEPOINT CREATE_AG_DN_PVT;
2066:
2067: l_ag_dn_xref_rec := p_ag_dn_xref_rec;
2068:

Line 2069: -- Standard call to check for call compatibility.

2065: SAVEPOINT CREATE_AG_DN_PVT;
2066:
2067: l_ag_dn_xref_rec := p_ag_dn_xref_rec;
2068:
2069: -- Standard call to check for call compatibility.
2070: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2071: p_api_version,
2072: l_api_name,
2073: G_PKG_NAME)

Line 2127: -- Standard check for p_commit

2123: --
2124: -- End of API body
2125: --
2126:
2127: -- Standard check for p_commit
2128: IF FND_API.to_Boolean( p_commit )
2129: THEN
2130: COMMIT WORK;
2131: END IF;

Line 2214: -- Standard Start of API savepoint

2210: errmsg VARCHAR2(32767);
2211:
2212: BEGIN
2213:
2214: -- Standard Start of API savepoint
2215: SAVEPOINT UPDATE_AG_DN_PVT;
2216:
2217: l_AG_DN_XREF_REC := p_AG_DN_XREF_rec;
2218:

Line 2219: -- Standard call to check for call compatibility.

2215: SAVEPOINT UPDATE_AG_DN_PVT;
2216:
2217: l_AG_DN_XREF_REC := p_AG_DN_XREF_rec;
2218:
2219: -- Standard call to check for call compatibility.
2220: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2221: p_api_version,
2222: l_api_name,
2223: G_PKG_NAME)

Line 2356: -- Standard check for p_commit

2352: --
2353: -- End of API body.
2354: --
2355:
2356: -- Standard check for p_commit
2357: IF FND_API.to_Boolean( p_commit )
2358: THEN
2359: COMMIT WORK;
2360: END IF;

Line 2421: -- Standard Start of API savepoint

2417: l_rowid Varchar2(50);
2418: errmsg VARCHAR2(32767);
2419:
2420: BEGIN
2421: -- Standard Start of API savepoint
2422: SAVEPOINT DELETE_AG_DN_PVT;
2423:
2424: -- Standard call to check for call compatibility.
2425: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2424: -- Standard call to check for call compatibility.

2420: BEGIN
2421: -- Standard Start of API savepoint
2422: SAVEPOINT DELETE_AG_DN_PVT;
2423:
2424: -- Standard call to check for call compatibility.
2425: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2426: p_api_version,
2427: l_api_name,
2428: G_PKG_NAME)

Line 2481: -- Standard check for p_commit

2477: --
2478: -- End of API body
2479: --
2480:
2481: -- Standard check for p_commit
2482: IF FND_API.to_Boolean( p_commit )
2483: THEN
2484: COMMIT WORK;
2485: END IF;

Line 2540: -- Standard Start of API savepoint

2536: l_Dunning_REC IEX_DUNNING_PUB.Dunning_REC_TYPE ;
2537: errmsg VARCHAR2(32767);
2538:
2539: BEGIN
2540: -- Standard Start of API savepoint
2541: SAVEPOINT CREATE_DUNNING_PVT;
2542:
2543: l_dunning_rec := p_dunning_rec;
2544:

Line 2545: -- Standard call to check for call compatibility.

2541: SAVEPOINT CREATE_DUNNING_PVT;
2542:
2543: l_dunning_rec := p_dunning_rec;
2544:
2545: -- Standard call to check for call compatibility.
2546: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2547: p_api_version,
2548: l_api_name,
2549: G_PKG_NAME)

Line 2623: -- Standard check for p_commit

2619: --
2620: -- End of API body
2621: --
2622:
2623: -- Standard check for p_commit
2624: IF FND_API.to_Boolean( p_commit )
2625: THEN
2626: COMMIT WORK;
2627: END IF;

Line 2730: -- Standard Start of API savepoint

2726: iex_dunn_trx_counter number := 0;
2727: t_id number;
2728: t_code varchar2(50);
2729: BEGIN
2730: -- Standard Start of API savepoint
2731: SAVEPOINT CREATE_STAGED_DUNNING_PVT;
2732:
2733: -- Standard call to check for call compatibility.
2734: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2733: -- Standard call to check for call compatibility.

2729: BEGIN
2730: -- Standard Start of API savepoint
2731: SAVEPOINT CREATE_STAGED_DUNNING_PVT;
2732:
2733: -- Standard call to check for call compatibility.
2734: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2735: p_api_version,
2736: l_api_name,
2737: G_PKG_NAME)

Line 3538: -- Standard check for p_commit

3534: --
3535: -- End of API body
3536: --
3537:
3538: -- Standard check for p_commit
3539: IF FND_API.to_Boolean( p_commit )
3540: THEN
3541: COMMIT WORK;
3542: END IF;

Line 3645: -- Standard Start of API savepoint

3641: errmsg VARCHAR2(32767);
3642:
3643: BEGIN
3644:
3645: -- Standard Start of API savepoint
3646: SAVEPOINT UPDATE_dunning_PVT;
3647:
3648: l_dunning_rec := p_dunning_rec;
3649:

Line 3650: -- Standard call to check for call compatibility.

3646: SAVEPOINT UPDATE_dunning_PVT;
3647:
3648: l_dunning_rec := p_dunning_rec;
3649:
3650: -- Standard call to check for call compatibility.
3651: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3652: p_api_version,
3653: l_api_name,
3654: G_PKG_NAME)

Line 3931: -- Standard check for p_commit

3927: --
3928: -- End of API body.
3929: --
3930:
3931: -- Standard check for p_commit
3932: IF FND_API.to_Boolean( p_commit )
3933: THEN
3934: COMMIT WORK;
3935: END IF;

Line 4265: -- Standard Start of API savepoint

4261: and hzca.party_id = p_party_id;
4262:
4263: l_dun_yn VARCHAR2(1):= 'Y';
4264: BEGIN
4265: -- Standard Start of API savepoint
4266: SAVEPOINT Send_Level_DUNNING_PVT;
4267:
4268: --Bug#4679639 schekuri 20-OCT-2005
4269: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation

Line 4274: -- Standard call to check for call compatibility.

4270: --l_org_id := fnd_profile.value('ORG_ID');
4271: l_org_id:= mo_global.get_current_org_id;
4272: WriteLog(' org_id in send_level_dunning ' || l_org_id);
4273:
4274: -- Standard call to check for call compatibility.
4275: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4276: p_api_version,
4277: l_api_name,
4278: G_PKG_NAME)

Line 5458: -- Standard Start of API savepoint

5454: t_id number;
5455: t_code varchar2(50);
5456:
5457: BEGIN
5458: -- Standard Start of API savepoint
5459: SAVEPOINT Send_Level_Staged_Dunning_PVT;
5460:
5461: --Bug#4679639 schekuri 20-OCT-2005
5462: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation

Line 5467: -- Standard call to check for call compatibility.

5463: --l_org_id := fnd_profile.value('ORG_ID');
5464: l_org_id:= mo_global.get_current_org_id;
5465: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_org_id = ' || l_org_id);
5466:
5467: -- Standard call to check for call compatibility.
5468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5469: p_api_version,
5470: l_api_name,
5471: G_PKG_NAME)

Line 7085: -- Standard Start of API savepoint

7081: and (disposition_code in ('GRANTED','NEGOTIATION')
7082: OR (disposition_code is NULL));
7083: l_dun_yn varchar2(1) := 'Y';
7084: BEGIN
7085: -- Standard Start of API savepoint
7086: SAVEPOINT Send_DUNNING_PVT;
7087:
7088: --Bug#4679639 schekuri 20-OCT-2005
7089: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation

Line 7093: -- Standard call to check for call compatibility.

7089: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
7090: --l_org_id := fnd_profile.value('ORG_ID');
7091: l_org_id:= mo_global.get_current_org_id;
7092: WriteLog(' org_id in send dunning '|| l_org_id);
7093: -- Standard call to check for call compatibility.
7094: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
7095: p_api_version,
7096: l_api_name,
7097: G_PKG_NAME)

Line 8286: -- Standard Start of API savepoint

8282: l_inv_xdo_template_id number;
8283: l_invoice_copies varchar(10);
8284:
8285: BEGIN
8286: -- Standard Start of API savepoint
8287: SAVEPOINT Send_Staged_Dunning_PVT;
8288:
8289: --Bug#4679639 schekuri 20-OCT-2005
8290: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation

Line 8295: -- Standard call to check for call compatibility.

8291: --l_org_id := fnd_profile.value('ORG_ID');
8292: l_org_id:= mo_global.get_current_org_id;
8293: WriteLog(G_PKG_NAME || ' ' || l_api_name ||' org_id in send dunning '|| l_org_id);
8294:
8295: -- Standard call to check for call compatibility.
8296: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
8297: p_api_version,
8298: l_api_name,
8299: G_PKG_NAME)

Line 9310: -- Standard Start of API savepoint

9306: l_total_amount_due_remaining number;
9307: l_cust_acct_cm_tot_amt_rem number;
9308:
9309: BEGIN
9310: -- Standard Start of API savepoint
9311: SAVEPOINT Resend_Level_DUNNING_PVT;
9312:
9313: --Bug#4679639 schekuri 20-OCT-2005
9314: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation

Line 9317: -- Standard call to check for call compatibility.

9313: --Bug#4679639 schekuri 20-OCT-2005
9314: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
9315: l_org_id:= mo_global.get_current_org_id;
9316:
9317: -- Standard call to check for call compatibility.
9318: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
9319: p_api_version,
9320: l_api_name,
9321: G_PKG_NAME)

Line 10158: -- Standard check for p_commit

10154: x_request_id := l_request_id;
10155: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - request_id='||x_request_id, l_write);
10156: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - status='||x_return_status, l_write);
10157:
10158: -- Standard check for p_commit
10159: IF FND_API.to_Boolean( p_commit )
10160: THEN
10161: COMMIT WORK;
10162: END IF;

Line 10374: -- Standard Start of API savepoint

10370: where dunning_id = p_dunning_id;
10371:
10372: temp_dunning_id number; -- for bug 16290958
10373: BEGIN
10374: -- Standard Start of API savepoint
10375: SAVEPOINT Resend_Level_Stg_Dunn_PVT;
10376:
10377: --Bug#4679639 schekuri 20-OCT-2005
10378: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation

Line 10381: -- Standard call to check for call compatibility.

10377: --Bug#4679639 schekuri 20-OCT-2005
10378: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
10379: l_org_id:= mo_global.get_current_org_id;
10380:
10381: -- Standard call to check for call compatibility.
10382: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
10383: p_api_version,
10384: l_api_name,
10385: G_PKG_NAME)

Line 11118: -- Standard check for p_commit

11114: x_request_id := l_request_id;
11115: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - request_id='||x_request_id, l_write);
11116: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - status='||x_return_status, l_write);
11117:
11118: -- Standard check for p_commit
11119: IF FND_API.to_Boolean( p_commit )
11120: THEN
11121: COMMIT WORK;
11122: END IF;

Line 11303: -- Standard Start of API savepoint

11299: from iex_dunnings dunn
11300: where dunning_id = p_dunning_id;
11301:
11302: BEGIN
11303: -- Standard Start of API savepoint
11304: SAVEPOINT Resend_DUNNING_PVT;
11305:
11306: --Bug#4679639 schekuri 20-OCT-2005
11307: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation

Line 11311: -- Standard call to check for call compatibility.

11307: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
11308: --l_org_id := fnd_profile.value('ORG_ID');
11309: l_org_id:= mo_global.get_current_org_id;
11310:
11311: -- Standard call to check for call compatibility.
11312: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
11313: p_api_version,
11314: l_api_name,
11315: G_PKG_NAME)

Line 11901: -- Standard check for p_commit

11897: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
11898: raise FND_API.G_EXC_UNEXPECTED_ERROR;
11899: END IF;
11900:
11901: -- Standard check for p_commit
11902: IF FND_API.to_Boolean( p_commit )
11903: THEN
11904: COMMIT WORK;
11905: END IF;

Line 12114: -- Standard Start of API savepoint

12110:
12111: temp_dunning_id number; -- added for bug 16290958
12112:
12113: BEGIN
12114: -- Standard Start of API savepoint
12115: SAVEPOINT Resend_Staged_Dunning_PVT;
12116:
12117: --Bug#4679639 schekuri 20-OCT-2005
12118: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation

Line 12122: -- Standard call to check for call compatibility.

12118: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
12119: --l_org_id := fnd_profile.value('ORG_ID');
12120: l_org_id:= mo_global.get_current_org_id;
12121:
12122: -- Standard call to check for call compatibility.
12123: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
12124: p_api_version,
12125: l_api_name,
12126: G_PKG_NAME)

Line 12709: -- Standard check for p_commit

12705: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
12706: raise FND_API.G_EXC_UNEXPECTED_ERROR;
12707: END IF;
12708:
12709: -- Standard check for p_commit
12710: IF FND_API.to_Boolean( p_commit )
12711: THEN
12712: COMMIT WORK;
12713: END IF;

Line 12852: -- Standard Start of API savepoint

12848:
12849: errmsg VARCHAR2(32767);
12850:
12851: BEGIN
12852: -- Standard Start of API savepoint
12853: SAVEPOINT AGING_DEL_PVT;
12854:
12855: l_commit := FND_API.G_TRUE;
12856:

Line 13444: -- Standard call to get message count and IF count is 1, get message info.

13440:
13441: x_callback_date := l_result;
13442: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - callback_date='||x_callback_date);
13443:
13444: -- Standard call to get message count and IF count is 1, get message info.
13445:
13446: FND_MSG_PUB.Count_And_Get
13447: ( p_count => x_msg_count,
13448: p_data => x_msg_data );

Line 15221: -- Standard Start of API savepoint

15217: l_primary VARCHAR2(10);
15218:
15219: BEGIN
15220:
15221: -- Standard Start of API savepoint
15222: SAVEPOINT GetContactInfo_PVT;
15223:
15224: l_commit := p_commit;
15225: x_contact_party_id := p_party_id; -- default to origal party_id until updated #3955222

Line 15564: -- Standard Start of API savepoint

15560: --
15561:
15562: BEGIN
15563:
15564: -- Standard Start of API savepoint
15565: SAVEPOINT GetContactPoint_PVT;
15566:
15567: l_commit := p_commit;
15568:

Line 16028: -- Standard check for p_commit

16024: --
16025: -- End of API body
16026: --
16027:
16028: -- Standard check for p_commit
16029: IF FND_API.to_Boolean( p_commit )
16030: THEN
16031: COMMIT WORK;
16032: END IF;

Line 16208: -- Standard check for p_commit

16204: --
16205: -- End of API body
16206: --
16207:
16208: -- Standard check for p_commit
16209: IF FND_API.to_Boolean( p_commit )
16210: THEN
16211: COMMIT WORK;
16212: END IF;

Line 16333: -- Standard Start of API savepoint

16329: l_object_version_number JTF_TASKS_B.OBJECT_VERSION_NUMBER%TYPE;
16330: --End bug 7317666 21-Nov-2008 barathsr
16331:
16332: BEGIN
16333: -- Standard Start of API savepoint
16334: SAVEPOINT DAILY_DUNNING_PVT;
16335:
16336: -- Standard call to check for call compatibility.
16337: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 16336: -- Standard call to check for call compatibility.

16332: BEGIN
16333: -- Standard Start of API savepoint
16334: SAVEPOINT DAILY_DUNNING_PVT;
16335:
16336: -- Standard call to check for call compatibility.
16337: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
16338: p_api_version,
16339: l_api_name,
16340: G_PKG_NAME)

Line 16554: -- Standard check for p_commit

16550: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunnUpdatedNum='||nCnt);
16551: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunnUpdatedNum='||dunning_tbl.count);
16552: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - ==========END SUMMARY=========');
16553:
16554: -- Standard check for p_commit
16555: IF FND_API.to_Boolean( p_commit )
16556: THEN
16557: COMMIT WORK;
16558: END IF;

Line 17400: -- Standard Start of API savepoint

17396: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
17397: iex_debug_pub.LogMessage ('Get_Resource: ' || 'iexvdunb.pls:GetRS:starting');
17398: END IF;
17399:
17400: -- Standard Start of API savepoint
17401: SAVEPOINT GET_RESOURCE_PVT;
17402:
17403: -- Standard call to check for call compatibility.
17404: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 17403: -- Standard call to check for call compatibility.

17399:
17400: -- Standard Start of API savepoint
17401: SAVEPOINT GET_RESOURCE_PVT;
17402:
17403: -- Standard call to check for call compatibility.
17404: IF NOT FND_API.Compatible_API_Call (l_api_version,
17405: p_api_version,
17406: l_api_name,
17407: G_PKG_NAME)

Line 17487: -- Standard check for p_commit

17483: --
17484: -- End of API body
17485: --
17486:
17487: -- Standard check for p_commit
17488: IF FND_API.to_Boolean( p_commit )
17489: THEN
17490: COMMIT WORK;
17491: END IF;

Line 17495: -- Standard call to get message count and if count is 1, get message info.

17491: END IF;
17492:
17493: WriteLog('iexvdunb.pls:GetRS:END');
17494:
17495: -- Standard call to get message count and if count is 1, get message info.
17496: FND_MSG_PUB.Count_And_Get
17497: ( p_count => x_msg_count,
17498: p_data => x_msg_data
17499: );

Line 18436: -- Standard Start of API savepoint

18432: l_curr_count number := 0;
18433: l_grace_days number; -- bug 14772139
18434:
18435: BEGIN
18436: -- Standard Start of API savepoint
18437: SAVEPOINT INSERT_DUNNING_TRANSACTION_PVT;
18438:
18439: -- Standard call to check for call compatibility.
18440: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 18439: -- Standard call to check for call compatibility.

18435: BEGIN
18436: -- Standard Start of API savepoint
18437: SAVEPOINT INSERT_DUNNING_TRANSACTION_PVT;
18438:
18439: -- Standard call to check for call compatibility.
18440: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
18441: p_api_version,
18442: l_api_name,
18443: G_PKG_NAME)

Line 19024: -- Standard check for p_commit

19020: --
19021: -- End of API body
19022: --
19023:
19024: -- Standard check for p_commit
19025: IF FND_API.to_Boolean( p_commit )
19026: THEN
19027: COMMIT WORK;
19028: END IF;