eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_DUNNING_PVT dependencies on FND_MESSAGE

Line 836: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_MULT_LOC');

832: -- if more then 1 regular bill-to then set error
833: if l_bill_to_count > 1 then
834: X_LOCATION_ID := null;
835: WriteLog(l_api_name || ': ERROR: Multiple Bill-To locations found');
836: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_MULT_LOC');
837: FND_MESSAGE.Set_Token('USAGE', 'bill-to', FALSE);
838: FND_MSG_PUB.Add;
839: x_return_status := FND_API.G_RET_STS_ERROR;
840: else

Line 837: FND_MESSAGE.Set_Token('USAGE', 'bill-to', FALSE);

833: if l_bill_to_count > 1 then
834: X_LOCATION_ID := null;
835: WriteLog(l_api_name || ': ERROR: Multiple Bill-To locations found');
836: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_MULT_LOC');
837: FND_MESSAGE.Set_Token('USAGE', 'bill-to', FALSE);
838: FND_MSG_PUB.Add;
839: x_return_status := FND_API.G_RET_STS_ERROR;
840: else
841: X_LOCATION_ID := l_location_id;

Line 1189: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_ACCOUNT');

1185: l_primary_flag;
1186: CLOSE get_data_crs;
1187:
1188: if l_cust_account_id is null then
1189: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_ACCOUNT');
1190: FND_MSG_PUB.ADD;
1191: RAISE FND_API.G_EXC_ERROR;
1192: end if;
1193:

Line 1210: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_MULT_LOC');

1206:
1207: -- if more then 1 regular bill-to then set error
1208: if l_count > 1 then
1209: WriteLog(l_api_name || ': ERROR: Multiple locations found');
1210: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_MULT_LOC');
1211: FND_MESSAGE.Set_Token('USAGE', l_site_use_code, FALSE);
1212: FND_MSG_PUB.Add;
1213: x_return_status := FND_API.G_RET_STS_ERROR;
1214: end if;

Line 1211: FND_MESSAGE.Set_Token('USAGE', l_site_use_code, FALSE);

1207: -- if more then 1 regular bill-to then set error
1208: if l_count > 1 then
1209: WriteLog(l_api_name || ': ERROR: Multiple locations found');
1210: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_MULT_LOC');
1211: FND_MESSAGE.Set_Token('USAGE', l_site_use_code, FALSE);
1212: FND_MSG_PUB.Add;
1213: x_return_status := FND_API.G_RET_STS_ERROR;
1214: end if;
1215:

Line 1995: FND_MESSAGE.Set_Name('IEX', 'API_INVALID_ID');

1991:
1992: IF P_delinquency_ID is NULL
1993: or P_delinquency_ID = FND_API.G_MISS_NUM
1994: THEN
1995: FND_MESSAGE.Set_Name('IEX', 'API_INVALID_ID');
1996: FND_MESSAGE.Set_Token('COLUMN', 'delinquency_ID', FALSE);
1997: FND_MESSAGE.Set_Token('VALUE', p_delinquency_id, FALSE);
1998: FND_MSG_PUB.Add;
1999: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1996: FND_MESSAGE.Set_Token('COLUMN', 'delinquency_ID', FALSE);

1992: IF P_delinquency_ID is NULL
1993: or P_delinquency_ID = FND_API.G_MISS_NUM
1994: THEN
1995: FND_MESSAGE.Set_Name('IEX', 'API_INVALID_ID');
1996: FND_MESSAGE.Set_Token('COLUMN', 'delinquency_ID', FALSE);
1997: FND_MESSAGE.Set_Token('VALUE', p_delinquency_id, FALSE);
1998: FND_MSG_PUB.Add;
1999: x_return_status := FND_API.G_RET_STS_ERROR;
2000:

Line 1997: FND_MESSAGE.Set_Token('VALUE', p_delinquency_id, FALSE);

1993: or P_delinquency_ID = FND_API.G_MISS_NUM
1994: THEN
1995: FND_MESSAGE.Set_Name('IEX', 'API_INVALID_ID');
1996: FND_MESSAGE.Set_Token('COLUMN', 'delinquency_ID', FALSE);
1997: FND_MESSAGE.Set_Token('VALUE', p_delinquency_id, FALSE);
1998: FND_MSG_PUB.Add;
1999: x_return_status := FND_API.G_RET_STS_ERROR;
2000:
2001: ELSE

Line 2010: FND_MESSAGE.Set_Name('IEX', 'API_INVALID_ID');

2006: IF (C_Get_Del%NOTFOUND)
2007: THEN
2008: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
2009: THEN
2010: FND_MESSAGE.Set_Name('IEX', 'API_INVALID_ID');
2011: FND_MESSAGE.Set_Token('COLUMN', 'delinquency_ID', FALSE);
2012: FND_MESSAGE.Set_Token('VALUE', p_delinquency_id, FALSE);
2013: FND_MSG_PUB.Add;
2014: END IF;

Line 2011: FND_MESSAGE.Set_Token('COLUMN', 'delinquency_ID', FALSE);

2007: THEN
2008: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
2009: THEN
2010: FND_MESSAGE.Set_Name('IEX', 'API_INVALID_ID');
2011: FND_MESSAGE.Set_Token('COLUMN', 'delinquency_ID', FALSE);
2012: FND_MESSAGE.Set_Token('VALUE', p_delinquency_id, FALSE);
2013: FND_MSG_PUB.Add;
2014: END IF;
2015: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2012: FND_MESSAGE.Set_Token('VALUE', p_delinquency_id, FALSE);

2008: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
2009: THEN
2010: FND_MESSAGE.Set_Name('IEX', 'API_INVALID_ID');
2011: FND_MESSAGE.Set_Token('COLUMN', 'delinquency_ID', FALSE);
2012: FND_MESSAGE.Set_Token('VALUE', p_delinquency_id, FALSE);
2013: FND_MSG_PUB.Add;
2014: END IF;
2015: x_return_status := FND_API.G_RET_STS_ERROR;
2016: END IF;

Line 2258: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');

2254:
2255: If ( C_Get_AG_DN_XREF_REC%NOTFOUND) Then
2256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2257: THEN
2258: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
2259: FND_MESSAGE.Set_Token ('INFO', 'IEX_AG_DN_XREF', FALSE);
2260: FND_MSG_PUB.Add;
2261: END IF;
2262: raise FND_API.G_EXC_ERROR;

Line 2259: FND_MESSAGE.Set_Token ('INFO', 'IEX_AG_DN_XREF', FALSE);

2255: If ( C_Get_AG_DN_XREF_REC%NOTFOUND) Then
2256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2257: THEN
2258: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
2259: FND_MESSAGE.Set_Token ('INFO', 'IEX_AG_DN_XREF', FALSE);
2260: FND_MSG_PUB.Add;
2261: END IF;
2262: raise FND_API.G_EXC_ERROR;
2263: END IF;

Line 2273: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');

2269: l_ag_Dn_xref_rec.last_update_date = FND_API.G_MISS_Date )
2270: Then
2271: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2272: THEN
2273: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
2274: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2275: FND_MSG_PUB.ADD;
2276: END IF;
2277: raise FND_API.G_EXC_ERROR;

Line 2274: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

2270: Then
2271: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2272: THEN
2273: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
2274: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2275: FND_MSG_PUB.ADD;
2276: END IF;
2277: raise FND_API.G_EXC_ERROR;
2278: End if;

Line 2449: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

2445:
2446:
2447: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2448: THEN
2449: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2450: FND_MESSAGE.Set_Token ('INFO', 'IEX_AG_DN_XREF', FALSE);
2451: FND_MSG_PUB.Add;
2452: END IF;
2453: raise FND_API.G_EXC_ERROR;

Line 2450: FND_MESSAGE.Set_Token ('INFO', 'IEX_AG_DN_XREF', FALSE);

2446:
2447: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2448: THEN
2449: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2450: FND_MESSAGE.Set_Token ('INFO', 'IEX_AG_DN_XREF', FALSE);
2451: FND_MSG_PUB.Add;
2452: END IF;
2453: raise FND_API.G_EXC_ERROR;
2454: END IF;

Line 2774: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

2770:
2771: If ( C_GET_DUNNING_REC%NOTFOUND) Then
2772: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2773: THEN
2774: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2775: FND_MESSAGE.Set_Token ('INFO', 'iex_DUNNINGs', FALSE);
2776: FND_MSG_PUB.Add;
2777: END IF;
2778: raise FND_API.G_EXC_ERROR;

Line 2775: FND_MESSAGE.Set_Token ('INFO', 'iex_DUNNINGs', FALSE);

2771: If ( C_GET_DUNNING_REC%NOTFOUND) Then
2772: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2773: THEN
2774: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2775: FND_MESSAGE.Set_Token ('INFO', 'iex_DUNNINGs', FALSE);
2776: FND_MSG_PUB.Add;
2777: END IF;
2778: raise FND_API.G_EXC_ERROR;
2779: END IF;

Line 2790: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');

2786: l_dunning_rec.last_update_date = FND_API.G_MISS_Date )
2787: Then
2788: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2789: THEN
2790: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
2791: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2792: FND_MSG_PUB.ADD;
2793: END IF;
2794: raise FND_API.G_EXC_ERROR;

Line 2791: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

2787: Then
2788: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2789: THEN
2790: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
2791: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2792: FND_MSG_PUB.ADD;
2793: END IF;
2794: raise FND_API.G_EXC_ERROR;
2795: End if;

Line 3281: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_SCORE');

3277: Open C_Get_SCORE(l_object_id, l_object_Code, p_dunning_plan_id);
3278: Fetch C_Get_SCORE into l_score;
3279:
3280: If ( C_GET_SCORE%NOTFOUND) Then
3281: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_SCORE');
3282: FND_MSG_PUB.Add;
3283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing Score');
3284: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing Score');
3285: Close C_Get_SCORE;

Line 3315: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');

3311: , x_aging_bucket_line_id => l_bucket_line_id);
3312:
3313: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - AgingDel status='||x_return_status);
3314: If ( x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3315: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');
3316: FND_MSG_PUB.Add;
3317: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - AgingBucketLineId notfound');
3318: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AgingBucketLineId NotFound');
3319: RAISE FND_API.G_EXC_ERROR;

Line 3337: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

3333: l_callback_flag,
3334: l_callback_days;
3335:
3336: If ( C_GET_TEMPLATE%NOTFOUND) Then
3337: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
3338: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);
3339: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
3340: FND_MSG_PUB.Add;
3341: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');

Line 3338: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);

3334: l_callback_days;
3335:
3336: If ( C_GET_TEMPLATE%NOTFOUND) Then
3337: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
3338: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);
3339: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
3340: FND_MSG_PUB.Add;
3341: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
3342: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template');

Line 3339: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');

3335:
3336: If ( C_GET_TEMPLATE%NOTFOUND) Then
3337: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
3338: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);
3339: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
3340: FND_MSG_PUB.Add;
3341: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
3342: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template');
3343: RAISE FND_API.G_EXC_ERROR;

Line 3366: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');

3362: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - curr d_method='||l_curr_dmethod);
3363: if ( (l_curr_dmethod is null or l_curr_dmethod = '') or
3364: (l_curr_dmethod = 'FFM' and l_template_id is null) or
3365: (l_curr_dmethod = 'XML' and l_xdo_template_id is null ) ) then
3366: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
3367: FND_MSG_PUB.Add;
3368: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
3369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template');
3370: RAISE FND_API.G_EXC_ERROR;

Line 3405: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_PROFILE_NO');

3401: , p_cust_account_id => l_account_id_check
3402: , p_site_use_id => l_customer_site_use_id_check
3403: , p_delinquency_id => l_delinquency_id_check ) = 'N'
3404: ) then
3405: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_PROFILE_NO');
3406: FND_MSG_PUB.Add;
3407: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Send dunning in customer profile set to no ');
3408: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Send dunning in customer profile set to no ');
3409: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3419: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');

3415: if ( iex_utilities.DunningMinAmountCheck (
3416: p_cust_account_id => l_account_id_check
3417: , p_site_use_id => l_customer_site_use_id_check) = 'N'
3418: ) then
3419: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');
3420: FND_MSG_PUB.Add;
3421: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Required min Dunning amount in customer profile ');
3422: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Required min Dunning amount in customer profile ');
3423: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3481: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_CALLBACKDATE');

3477:
3478: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - GetCallbackDate status='|| x_return_status);
3479:
3480: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3481: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_CALLBACKDATE');
3482: FND_MSG_PUB.Add;
3483: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot find callback date');
3484: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot find callback date');
3485: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3954: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

3950:
3951: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - AgingDel status='||x_return_status);
3952:
3953: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3954: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
3955: --FND_MESSAGE.Set_Token ('INFO', 'iex:AginBucketLineId', FALSE);
3956: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');
3957: FND_MSG_PUB.Add;
3958: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Get AgingBucketLineId');

Line 3955: --FND_MESSAGE.Set_Token ('INFO', 'iex:AginBucketLineId', FALSE);

3951: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - AgingDel status='||x_return_status);
3952:
3953: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3954: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
3955: --FND_MESSAGE.Set_Token ('INFO', 'iex:AginBucketLineId', FALSE);
3956: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');
3957: FND_MSG_PUB.Add;
3958: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Get AgingBucketLineId');
3959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot AgingBucketLineId' );

Line 3956: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');

3952:
3953: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3954: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
3955: --FND_MESSAGE.Set_Token ('INFO', 'iex:AginBucketLineId', FALSE);
3956: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');
3957: FND_MSG_PUB.Add;
3958: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Get AgingBucketLineId');
3959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot AgingBucketLineId' );
3960: --msg

Line 3994: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');

3990: l_callback_days,
3991: l_bucket;
3992:
3993: If ( C_GET_TEMPLATE%NOTFOUND) Then
3994: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
3995: FND_MSG_PUB.Add;
3996: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
3997: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template' );
3998: Close C_Get_TEMPLATE;

Line 4022: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

4018: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - curr d_method='||l_curr_dmethod);
4019: if ( (l_curr_dmethod is null or l_curr_dmethod = '') or
4020: (l_curr_dmethod = 'FFM' and l_template_id is null) or
4021: (l_curr_dmethod = 'XML' and l_xdo_template_id is null ) ) then
4022: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
4023: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);
4024: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
4025: FND_MSG_PUB.Add;
4026: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');

Line 4023: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);

4019: if ( (l_curr_dmethod is null or l_curr_dmethod = '') or
4020: (l_curr_dmethod = 'FFM' and l_template_id is null) or
4021: (l_curr_dmethod = 'XML' and l_xdo_template_id is null ) ) then
4022: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
4023: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);
4024: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
4025: FND_MSG_PUB.Add;
4026: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
4027: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template' );

Line 4024: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');

4020: (l_curr_dmethod = 'FFM' and l_template_id is null) or
4021: (l_curr_dmethod = 'XML' and l_xdo_template_id is null ) ) then
4022: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
4023: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);
4024: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
4025: FND_MSG_PUB.Add;
4026: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
4027: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template' );
4028: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4044: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_PROFILE_NO');

4040: , p_cust_account_id => l_account_id
4041: , p_site_use_id => l_customer_site_use_id
4042: , p_delinquency_id => l_delinquency_id ) = 'N'
4043: ) then
4044: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_PROFILE_NO');
4045: FND_MSG_PUB.Add;
4046: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Send dunning in customer profile set to no ');
4047: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Send dunning in customer profile set to no ');
4048: GOTO end_loop;

Line 4057: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');

4053: if ( iex_utilities.DunningMinAmountCheck (
4054: p_cust_account_id => l_account_id
4055: , p_site_use_id => l_customer_site_use_id) = 'N'
4056: ) then
4057: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');
4058: FND_MSG_PUB.Add;
4059: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Required min Dunning amount in customer profile ');
4060: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Required min Dunning amount in customer profile ');
4061: GOTO end_loop;

Line 4137: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

4133: l_amount,
4134: l_curr_code;
4135:
4136: If ( C_AMOUNT%NOTFOUND) Then
4137: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
4138: FND_MESSAGE.Set_Token ('INFO', 'iex:amount', FALSE);
4139: FND_MSG_PUB.Add;
4140: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - amount notfound');
4141: END IF;

Line 4138: FND_MESSAGE.Set_Token ('INFO', 'iex:amount', FALSE);

4134: l_curr_code;
4135:
4136: If ( C_AMOUNT%NOTFOUND) Then
4137: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
4138: FND_MESSAGE.Set_Token ('INFO', 'iex:amount', FALSE);
4139: FND_MSG_PUB.Add;
4140: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - amount notfound');
4141: END IF;
4142:

Line 4624: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

4620: Open C_Get_SCORE(l_object_id, l_object_Code, p_dunning_plan_id);
4621: Fetch C_Get_SCORE into l_score;
4622:
4623: If ( C_GET_SCORE%NOTFOUND) Then
4624: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
4625: --FND_MESSAGE.Set_Token ('INFO', 'Score', FALSE);
4626: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_SCORE');
4627: FND_MSG_PUB.Add;
4628: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Score NotFound');

Line 4625: --FND_MESSAGE.Set_Token ('INFO', 'Score', FALSE);

4621: Fetch C_Get_SCORE into l_score;
4622:
4623: If ( C_GET_SCORE%NOTFOUND) Then
4624: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
4625: --FND_MESSAGE.Set_Token ('INFO', 'Score', FALSE);
4626: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_SCORE');
4627: FND_MSG_PUB.Add;
4628: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Score NotFound');
4629: Close C_Get_SCORE;

Line 4626: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_SCORE');

4622:
4623: If ( C_GET_SCORE%NOTFOUND) Then
4624: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
4625: --FND_MESSAGE.Set_Token ('INFO', 'Score', FALSE);
4626: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_SCORE');
4627: FND_MSG_PUB.Add;
4628: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Score NotFound');
4629: Close C_Get_SCORE;
4630: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4664: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

4660:
4661: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - AgingDel status='||x_return_status);
4662:
4663: If ( x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
4664: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
4665: --FND_MESSAGE.Set_Token ('INFO', 'AgingBucketLineId', FALSE);
4666: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');
4667: FND_MSG_PUB.Add;
4668: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - AgingBucketLineId notfound');

Line 4665: --FND_MESSAGE.Set_Token ('INFO', 'AgingBucketLineId', FALSE);

4661: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - AgingDel status='||x_return_status);
4662:
4663: If ( x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
4664: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
4665: --FND_MESSAGE.Set_Token ('INFO', 'AgingBucketLineId', FALSE);
4666: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');
4667: FND_MSG_PUB.Add;
4668: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - AgingBucketLineId notfound');
4669: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4666: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');

4662:
4663: If ( x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
4664: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
4665: --FND_MESSAGE.Set_Token ('INFO', 'AgingBucketLineId', FALSE);
4666: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');
4667: FND_MSG_PUB.Add;
4668: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - AgingBucketLineId notfound');
4669: x_return_status := FND_API.G_RET_STS_ERROR;
4670: GOTO end_api;

Line 4690: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');

4686: l_callback_flag,
4687: l_callback_days;
4688:
4689: If ( C_GET_TEMPLATE%NOTFOUND) Then
4690: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
4691: FND_MSG_PUB.Add;
4692: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - template notfound');
4693: x_return_status := FND_API.G_RET_STS_ERROR;
4694: GOTO end_api;

Line 4715: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

4711: WriteLog('iexvdunb:ResendLevelDunn:curr d_method='||l_curr_dmethod);
4712: if ( (l_curr_dmethod is null or l_curr_dmethod = '') or
4713: (l_curr_dmethod = 'FFM' and l_template_id is null) or
4714: (l_curr_dmethod = 'XML' and l_xdo_template_id is null ) ) then
4715: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
4716: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);
4717: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
4718: FND_MSG_PUB.Add;
4719: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template notfound');

Line 4716: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);

4712: if ( (l_curr_dmethod is null or l_curr_dmethod = '') or
4713: (l_curr_dmethod = 'FFM' and l_template_id is null) or
4714: (l_curr_dmethod = 'XML' and l_xdo_template_id is null ) ) then
4715: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
4716: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);
4717: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
4718: FND_MSG_PUB.Add;
4719: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template notfound');
4720: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4717: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');

4713: (l_curr_dmethod = 'FFM' and l_template_id is null) or
4714: (l_curr_dmethod = 'XML' and l_xdo_template_id is null ) ) then
4715: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
4716: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);
4717: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
4718: FND_MSG_PUB.Add;
4719: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template notfound');
4720: x_return_status := FND_API.G_RET_STS_ERROR;
4721: GOTO end_api;

Line 4756: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_PROFILE_NO');

4752: , p_cust_account_id => l_account_id_check
4753: , p_site_use_id => l_customer_site_use_id_check
4754: , p_delinquency_id => l_delinquency_id_check ) = 'N'
4755: ) then
4756: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_PROFILE_NO');
4757: FND_MSG_PUB.Add;
4758: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Send dunning in customer profile set to no ');
4759: x_return_status := FND_API.G_RET_STS_ERROR;
4760: GOTO end_api;

Line 4769: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');

4765: if ( iex_utilities.DunningMinAmountCheck (
4766: p_cust_account_id => l_account_id_check
4767: , p_site_use_id => l_customer_site_use_id_check) = 'N'
4768: ) then
4769: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');
4770: FND_MSG_PUB.Add;
4771: WriteLog('iexvdunb:ResendLevelDunn: Required min Dunning amount in customer profile ');
4772: x_return_status := FND_API.G_RET_STS_ERROR;
4773: GOTO end_api;

Line 4922: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_CALLBACKDATE');

4918:
4919: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - GetCallbackDate status='|| x_return_status, l_write);
4920:
4921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4922: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_CALLBACKDATE');
4923: FND_MSG_PUB.Add;
4924: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Not Get CallbackDate', l_write);
4925: x_return_status := FND_API.G_RET_STS_ERROR;
4926: GOTO end_api;

Line 5299: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');

5295:
5296: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - AgingDel status='||x_return_status);
5297:
5298: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5299: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');
5300: FND_MSG_PUB.Add;
5301: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Get AgingBucketLineId');
5302: GOTO end_loop;
5303: END IF;

Line 5324: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');

5320: l_callback_days,
5321: l_bucket;
5322:
5323: If ( C_GET_TEMPLATE%NOTFOUND) Then
5324: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
5325: FND_MSG_PUB.Add;
5326: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - template notfound');
5327: Close C_Get_TEMPLATE;
5328: GOTO end_loop;

Line 5352: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');

5348: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - curr d_method='||l_curr_dmethod);
5349: if ( (l_curr_dmethod is null or l_curr_dmethod = '') or
5350: (l_curr_dmethod = 'FFM' and l_template_id is null) or
5351: (l_curr_dmethod = 'XML' and l_xdo_template_id is null ) ) then
5352: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
5353: FND_MSG_PUB.Add;
5354: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template notfound');
5355: x_return_status := FND_API.G_RET_STS_ERROR;
5356: GOTO end_loop;

Line 5371: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_PROFILE_NO');

5367: , p_cust_account_id => l_account_id
5368: , p_site_use_id => l_customer_site_use_id
5369: , p_delinquency_id => l_delinquency_id ) = 'N'
5370: ) then
5371: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_PROFILE_NO');
5372: FND_MSG_PUB.Add;
5373: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Send dunning in customer profile set to no ');
5374: GOTO end_loop;
5375: end if;

Line 5383: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');

5379: if ( iex_utilities.DunningMinAmountCheck (
5380: p_cust_account_id => l_account_id
5381: , p_site_use_id => l_customer_site_use_id) = 'N'
5382: ) then
5383: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');
5384: FND_MSG_PUB.Add;
5385: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Required min Dunning amount in customer profile ');
5386: GOTO end_loop;
5387: end if;

Line 5561: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

5557: l_amount,
5558: l_curr_code;
5559:
5560: If ( C_AMOUNT%NOTFOUND) Then
5561: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
5562: FND_MESSAGE.Set_Token ('INFO', 'amount', FALSE);
5563: FND_MSG_PUB.Add;
5564: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - amount notfound');
5565: END IF;

Line 5562: FND_MESSAGE.Set_Token ('INFO', 'amount', FALSE);

5558: l_curr_code;
5559:
5560: If ( C_AMOUNT%NOTFOUND) Then
5561: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
5562: FND_MESSAGE.Set_Token ('INFO', 'amount', FALSE);
5563: FND_MSG_PUB.Add;
5564: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - amount notfound');
5565: END IF;
5566:

Line 5822: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_PAYMENTSCHEDULE');

5818: Open C_Get_PARTY_DAYS(p_object_id);
5819: Fetch C_Get_PARTY_DAYS into l_days;
5820: If ( C_GET_PARTY_DAYS%NOTFOUND) Then
5821: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - PaymentSchedId NotFound');
5822: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_PAYMENTSCHEDULE');
5823: FND_MSG_PUB.Add;
5824: l_return_status := FND_API.G_RET_STS_ERROR;
5825: Close C_Get_PARTY_DAYS;
5826: GOTO end_get_line;

Line 5835: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_PAYMENTSCHEDULE');

5831: Open C_Get_ACCT_DAYS(p_object_id);
5832: Fetch C_Get_ACCT_DAYS into l_days;
5833: If ( C_GET_ACCT_DAYS%NOTFOUND) Then
5834: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - PaymentSchedId NotFound');
5835: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_PAYMENTSCHEDULE');
5836: FND_MSG_PUB.Add;
5837: l_return_status := FND_API.G_RET_STS_ERROR;
5838: Close C_Get_ACCT_DAYS;
5839: GOTO end_get_line;

Line 5848: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_PAYMENTSCHEDULE');

5844: Open C_Get_SITE_DAYS(p_object_id);
5845: Fetch C_Get_SITE_DAYS into l_days;
5846: If ( C_GET_SITE_DAYS%NOTFOUND) Then
5847: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - PaymentSchedId NotFound');
5848: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_PAYMENTSCHEDULE');
5849: FND_MSG_PUB.Add;
5850: l_return_status := FND_API.G_RET_STS_ERROR;
5851: Close C_Get_SITE_DAYS;
5852: GOTO end_get_line;

Line 5865: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_PAYMENTSCHEDULE');

5861: Open C_Get_DAYS(p_delinquency_id);
5862: Fetch C_Get_DAYS into l_days;
5863: If ( C_GET_DAYS%NOTFOUND) Then
5864: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - PaymentSchedId NotFound');
5865: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_PAYMENTSCHEDULE');
5866: FND_MSG_PUB.Add;
5867: l_return_status := FND_API.G_RET_STS_ERROR;
5868: Close C_Get_DAYS;
5869: GOTO end_get_line;

Line 5881: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_BUCKET_LINE');

5877: Open C_Get_BUCKET_LINE(l_days, p_dunning_plan_id);
5878: Fetch C_Get_BUCKET_LINE into l_bucket_line_id;
5879: If ( C_GET_BUCKET_LINE%NOTFOUND) Then
5880: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - BucketLine NotFound');
5881: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_BUCKET_LINE');
5882: FND_MSG_PUB.Add;
5883: l_return_status := FND_API.G_RET_STS_ERROR;
5884: Close C_Get_BUCKET_LINE;
5885: GOTO end_get_line;

Line 6041: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');

6037:
6038: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - start');
6039: if (p_template_id is null) then
6040: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No TEMPLATE_ID');
6041: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6042: FND_MESSAGE.Set_Token ('INFO', 'No Template_ID');
6043: FND_MSG_PUB.Add;
6044: l_return_status := FND_API.G_RET_STS_ERROR;
6045: GOTO end_call_ffm;

Line 6042: FND_MESSAGE.Set_Token ('INFO', 'No Template_ID');

6038: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - start');
6039: if (p_template_id is null) then
6040: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No TEMPLATE_ID');
6041: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6042: FND_MESSAGE.Set_Token ('INFO', 'No Template_ID');
6043: FND_MSG_PUB.Add;
6044: l_return_status := FND_API.G_RET_STS_ERROR;
6045: GOTO end_call_ffm;
6046: end if;

Line 6049: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');

6045: GOTO end_call_ffm;
6046: end if;
6047: if (p_party_id is null) then
6048: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No PARTY_ID');
6049: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6050: FND_MESSAGE.Set_Token ('INFO', 'No Party_Id');
6051: FND_MSG_PUB.Add;
6052: l_return_status := FND_API.G_RET_STS_ERROR;
6053: GOTO end_call_ffm;

Line 6050: FND_MESSAGE.Set_Token ('INFO', 'No Party_Id');

6046: end if;
6047: if (p_party_id is null) then
6048: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No PARTY_ID');
6049: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6050: FND_MESSAGE.Set_Token ('INFO', 'No Party_Id');
6051: FND_MSG_PUB.Add;
6052: l_return_status := FND_API.G_RET_STS_ERROR;
6053: GOTO end_call_ffm;
6054: end if;

Line 6057: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');

6053: GOTO end_call_ffm;
6054: end if;
6055: if (p_method is null) then
6056: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No METHOD');
6057: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6058: FND_MESSAGE.Set_Token ('INFO', 'No Method');
6059: FND_MSG_PUB.Add;
6060: l_return_status := FND_API.G_RET_STS_ERROR;
6061: GOTO end_call_ffm;

Line 6058: FND_MESSAGE.Set_Token ('INFO', 'No Method');

6054: end if;
6055: if (p_method is null) then
6056: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No METHOD');
6057: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6058: FND_MESSAGE.Set_Token ('INFO', 'No Method');
6059: FND_MSG_PUB.Add;
6060: l_return_status := FND_API.G_RET_STS_ERROR;
6061: GOTO end_call_ffm;
6062: end if;

Line 6085: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');

6081: Open C_Get_ORG_EMAIL(p_party_id);
6082: Fetch C_Get_ORG_EMAIL into l_email;
6083: If ( C_GET_ORG_EMAIL%NOTFOUND) Then
6084: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Customer NotFound');
6085: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6086: FND_MESSAGE.Set_Token ('INFO', 'Customer NotFound');
6087: FND_MSG_PUB.Add;
6088: l_return_status := FND_API.G_RET_STS_ERROR;
6089: Close C_Get_ORG_EMAIL;

Line 6086: FND_MESSAGE.Set_Token ('INFO', 'Customer NotFound');

6082: Fetch C_Get_ORG_EMAIL into l_email;
6083: If ( C_GET_ORG_EMAIL%NOTFOUND) Then
6084: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Customer NotFound');
6085: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6086: FND_MESSAGE.Set_Token ('INFO', 'Customer NotFound');
6087: FND_MSG_PUB.Add;
6088: l_return_status := FND_API.G_RET_STS_ERROR;
6089: Close C_Get_ORG_EMAIL;
6090: Close C_Get_CONTACT_EMAIL;

Line 6096: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');

6092: end if;
6093: --
6094: If ( l_email is null ) Then
6095: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Email');
6096: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6097: FND_MESSAGE.Set_Token ('INFO', 'No Email_Address');
6098: FND_MSG_PUB.Add;
6099: l_return_status := FND_API.G_RET_STS_ERROR;
6100: Close C_Get_ORG_EMAIL;

Line 6097: FND_MESSAGE.Set_Token ('INFO', 'No Email_Address');

6093: --
6094: If ( l_email is null ) Then
6095: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Email');
6096: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6097: FND_MESSAGE.Set_Token ('INFO', 'No Email_Address');
6098: FND_MSG_PUB.Add;
6099: l_return_status := FND_API.G_RET_STS_ERROR;
6100: Close C_Get_ORG_EMAIL;
6101: Close C_Get_CONTACT_EMAIL;

Line 6110: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');

6106: end if;
6107:
6108: If ( l_email is null ) Then
6109: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Email');
6110: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6111: FND_MESSAGE.Set_Token ('INFO', 'No Email_Address');
6112: FND_MSG_PUB.Add;
6113: l_return_status := FND_API.G_RET_STS_ERROR;
6114: Close C_Get_CONTACT_EMAIL;

Line 6111: FND_MESSAGE.Set_Token ('INFO', 'No Email_Address');

6107:
6108: If ( l_email is null ) Then
6109: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Email');
6110: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6111: FND_MESSAGE.Set_Token ('INFO', 'No Email_Address');
6112: FND_MSG_PUB.Add;
6113: l_return_status := FND_API.G_RET_STS_ERROR;
6114: Close C_Get_CONTACT_EMAIL;
6115: GOTO end_call_ffm;

Line 6128: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');

6124: if (l_printer = '' or l_printer is null) then
6125: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
6126: IEX_DEBUG_PUB.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - No Printer');
6127: END IF;
6128: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6129: FND_MESSAGE.Set_Token ('INFO', 'No Printer');
6130: FND_MSG_PUB.Add;
6131: l_return_status := FND_API.G_RET_STS_ERROR;
6132: GOTO end_call_ffm;

Line 6129: FND_MESSAGE.Set_Token ('INFO', 'No Printer');

6125: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
6126: IEX_DEBUG_PUB.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - No Printer');
6127: END IF;
6128: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6129: FND_MESSAGE.Set_Token ('INFO', 'No Printer');
6130: FND_MSG_PUB.Add;
6131: l_return_status := FND_API.G_RET_STS_ERROR;
6132: GOTO end_call_ffm;
6133: end if;

Line 6148: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');

6144:
6145: If ( C_GET_CONTENTS%NOTFOUND ) Then
6146: if (nIdx = 0) then
6147: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Contents');
6148: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6149: FND_MESSAGE.Set_Token ('INFO', 'No Contents for selected template ');
6150: FND_MSG_PUB.Add;
6151: l_return_status := FND_API.G_RET_STS_ERROR;
6152: end if;

Line 6149: FND_MESSAGE.Set_Token ('INFO', 'No Contents for selected template ');

6145: If ( C_GET_CONTENTS%NOTFOUND ) Then
6146: if (nIdx = 0) then
6147: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Contents');
6148: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
6149: FND_MESSAGE.Set_Token ('INFO', 'No Contents for selected template ');
6150: FND_MSG_PUB.Add;
6151: l_return_status := FND_API.G_RET_STS_ERROR;
6152: end if;
6153: exit;

Line 6550: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_TEMPLATE');

6546:
6547: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - SEND_FFM:');
6548: if (p_template_id is null) then
6549: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No TEMPLATE_ID');
6550: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_TEMPLATE');
6551: FND_MSG_PUB.Add;
6552: l_return_status := FND_API.G_RET_STS_ERROR;
6553: GOTO end_call_ffm;
6554: end if;

Line 6557: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PARTY');

6553: GOTO end_call_ffm;
6554: end if;
6555: if (p_party_id is null AND (p_email IS NULL OR p_email = FND_API.G_MISS_CHAR)) then
6556: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No PARTY_ID or EMAIL');
6557: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PARTY');
6558: FND_MSG_PUB.Add;
6559: l_return_status := FND_API.G_RET_STS_ERROR;
6560: GOTO end_call_ffm;
6561: end if;

Line 6564: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_METHOD');

6560: GOTO end_call_ffm;
6561: end if;
6562: if (p_method is null) then
6563: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No METHOD');
6564: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_METHOD');
6565: FND_MSG_PUB.Add;
6566: l_return_status := FND_API.G_RET_STS_ERROR;
6567: GOTO end_call_ffm;
6568: end if;

Line 6575: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_SUBJECT');

6571: -- bug 3058620
6572: l_subject := NVL(FND_PROFILE.value('IEX_FULFILL_SUBJECT'), '');
6573: if (l_subject is null or l_subject = '') then
6574: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No FFM Subject',0);
6575: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_SUBJECT');
6576: FND_MSG_PUB.Add;
6577: l_return_status := FND_API.G_RET_STS_ERROR;
6578: GOTO end_call_ffm;
6579: end if;

Line 6674: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_FFMCONTENT');

6670:
6671: If ( C_GET_CONTENTS%NOTFOUND ) Then
6672: if (nIdx = 0) then
6673: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Contents NotFound');
6674: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_FFMCONTENT');
6675: FND_MSG_PUB.Add;
6676: l_return_status := FND_API.G_RET_STS_ERROR;
6677: end if;
6678: GOTO end_call_ffm;

Line 7120: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_OBJECT');

7116: l_return_status := FND_API.G_RET_STS_SUCCESS;
7117:
7118: if (p_object_code is null) then
7119: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No OBJECT_ID',0);
7120: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_OBJECT');
7121: FND_MSG_PUB.Add;
7122: l_return_status := FND_API.G_RET_STS_ERROR;
7123: GOTO end_call_ffm;
7124: end if;

Line 7128: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_TEMPLATE');

7124: end if;
7125:
7126: if (p_template_id is null) then
7127: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No TEMPLATE_ID',0);
7128: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_TEMPLATE');
7129: FND_MSG_PUB.Add;
7130: l_return_status := FND_API.G_RET_STS_ERROR;
7131: GOTO end_call_ffm;
7132: end if;

Line 7136: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PARTY');

7132: end if;
7133:
7134: if (p_party_id is null AND (p_email IS NULL OR p_email = FND_API.G_MISS_CHAR)) then
7135: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No PARTY_ID or EMAIL',0);
7136: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PARTY');
7137: FND_MSG_PUB.Add;
7138: l_return_status := FND_API.G_RET_STS_ERROR;
7139: GOTO end_call_ffm;
7140: end if;

Line 7144: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_METHOD');

7140: end if;
7141:
7142: if (p_method is null) then
7143: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No METHOD',0);
7144: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_METHOD');
7145: FND_MSG_PUB.Add;
7146: l_return_status := FND_API.G_RET_STS_ERROR;
7147: GOTO end_call_ffm;
7148: end if;

Line 7155: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_SUBJECT');

7151: -- bug 3058620
7152: l_subject := NVL(FND_PROFILE.value('IEX_FULFILL_SUBJECT'), '');
7153: if (l_subject is null or l_subject = '') then
7154: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No XML Subject');
7155: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_SUBJECT');
7156: FND_MSG_PUB.Add;
7157: l_return_status := FND_API.G_RET_STS_ERROR;
7158: GOTO end_call_ffm;
7159: end if;

Line 7179: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_RESOURCE');

7175: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - resource_id = ' || l_resource_id);
7176:
7177: if (l_resource_id is null) then
7178: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Resource for user '||l_user_id);
7179: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_RESOURCE');
7180: FND_MSG_PUB.Add;
7181: l_return_status := FND_API.G_RET_STS_ERROR;
7182: GOTO end_call_ffm;
7183: end if;

Line 7244: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DELIVERY');

7240: EXCEPTION
7241: WHEN OTHERS THEN
7242: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' throws exception');
7243: l_return_status := FND_API.G_RET_STS_ERROR;
7244: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DELIVERY');
7245: FND_MSG_PUB.Add;
7246: END;
7247:
7248: else -- either resending after error or sending for the first time

Line 7286: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_ADDRESS');

7282:
7283: -- checking for location
7284: IF l_location_id is null then
7285: WriteLog(G_PKG_NAME || ' ' || l_api_name || ': No location found');
7286: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_ADDRESS');
7287: FND_MSG_PUB.Add;
7288: l_return_status := FND_API.G_RET_STS_ERROR;
7289: GOTO end_call_ffm;
7290: end if;

Line 7310: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PRINTER');

7306: END IF;
7307:
7308: IF (l_printer = '' or l_printer is null) THEN
7309: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Printer',0);
7310: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PRINTER');
7311: FND_MSG_PUB.Add;
7312: l_return_status := FND_API.G_RET_STS_ERROR;
7313: GOTO end_call_ffm;
7314: END IF;

Line 7333: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_EMAIL');

7329:
7330: if l_contact_point_id is null then
7331: if p_method = 'EMAIL' then
7332: WriteLog(G_PKG_NAME || ' ' || l_api_name || ': No email found');
7333: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_EMAIL');
7334: FND_MSG_PUB.Add;
7335: ELSIF p_method = 'FAX' THEN
7336: WriteLog(G_PKG_NAME || ' ' || l_api_name || ': No fax found');
7337: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_FAX');

Line 7337: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_FAX');

7333: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_EMAIL');
7334: FND_MSG_PUB.Add;
7335: ELSIF p_method = 'FAX' THEN
7336: WriteLog(G_PKG_NAME || ' ' || l_api_name || ': No fax found');
7337: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_FAX');
7338: FND_MSG_PUB.Add;
7339: end if;
7340:
7341: l_return_status := FND_API.G_RET_STS_ERROR;

Line 7386: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_QUERY');

7382: Fetch C_Get_QUERY into l_query_id;
7383: If ( C_GET_QUERY%NOTFOUND ) Then
7384: if (nIdx = 0) then
7385: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Query NotFound');
7386: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_QUERY');
7387: FND_MSG_PUB.Add;
7388: l_return_status := FND_API.G_RET_STS_ERROR;
7389: GOTO end_call_ffm;
7390: end if;

Line 7439: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DELIVERY');

7435: EXCEPTION
7436: WHEN OTHERS THEN
7437: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' throws exception');
7438: l_return_status := FND_API.G_RET_STS_ERROR;
7439: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_DELIVERY');
7440: FND_MSG_PUB.Add;
7441: END;
7442:
7443: END IF;

Line 7455: FND_MESSAGE.PARSE_ENCODED(l_msg, l_app, l_msg_name);

7451: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7452:
7453: l_msg := FND_MSG_PUB.Get(p_msg_index => 1, p_encoded => 'T');
7454: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_msg: ' || l_msg);
7455: FND_MESSAGE.PARSE_ENCODED(l_msg, l_app, l_msg_name);
7456: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Error name: ' || l_msg_name);
7457:
7458: l_dunning_rec.DELIVERY_STATUS := l_msg_name;
7459:

Line 7728: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PARTY');

7724: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Start');
7725:
7726: if (p_party_id is null) then
7727: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No PARTY_ID');
7728: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PARTY');
7729: FND_MSG_PUB.Add;
7730: l_return_status := FND_API.G_RET_STS_ERROR;
7731: GOTO end_getcontact;
7732: end if;

Line 7735: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_METHOD');

7731: GOTO end_getcontact;
7732: end if;
7733: if (p_method is null) then
7734: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No METHOD');
7735: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_METHOD');
7736: FND_MSG_PUB.Add;
7737: l_return_status := FND_API.G_RET_STS_ERROR;
7738: GOTO end_getcontact;
7739: end if;

Line 7755: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PRINTER');

7751: l_printer := NVL(fnd_profile.value('IEX_FFM_PRINTER'), '');
7752: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Printer:'||l_printer);
7753: if (l_printer = '' or l_printer is null) then
7754: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Printer');
7755: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PRINTER');
7756: FND_MSG_PUB.Add;
7757: l_return_status := FND_API.G_RET_STS_ERROR;
7758: GOTO end_getcontact;
7759: end if;

Line 7768: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PARTYTYPE');

7764: Open C_Get_PARTY_TYPE(p_party_id);
7765: Fetch C_Get_PARTY_TYPE into l_party_type;
7766: If ( C_GET_PARTY_TYPE%NOTFOUND ) Then
7767: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - cannot find party type');
7768: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PARTYTYPE');
7769: FND_MSG_PUB.Add;
7770: l_return_status := FND_API.G_RET_STS_ERROR;
7771: Close C_Get_PARTY_TYPE;
7772: GOTO end_getcontact;

Line 7803: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_CONTACTINFO');

7799: IF (l_party_type = 'PERSON' and
7800: (x_contact is null or l_return_status <> FND_API.G_RET_STS_SUCCESS))
7801: then
7802: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - person contact NotFound');
7803: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_CONTACTINFO');
7804: FND_MSG_PUB.Add;
7805: l_return_status := FND_API.G_RET_STS_ERROR;
7806: GOTO end_getcontact;
7807: end if;

Line 7825: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_ORG');

7821: Open C_Get_ORG_PARTY(p_party_id);
7822: Fetch C_Get_ORG_PARTY into l_party_id;
7823: If ( C_GET_ORG_PARTY%NOTFOUND ) Then
7824: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - cannot find org party');
7825: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_ORG');
7826: FND_MSG_PUB.Add;
7827: l_return_status := FND_API.G_RET_STS_ERROR;
7828: Close C_Get_ORG_PARTY;
7829: GOTO end_getcontact;

Line 8075: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PARTY');

8071: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Start');
8072:
8073: if (p_party_id is null) then
8074: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No PARTY_ID');
8075: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PARTY');
8076: FND_MSG_PUB.Add;
8077: l_return_status := FND_API.G_RET_STS_ERROR;
8078: GOTO end_getcontact;
8079: end if;

Line 8082: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_METHOD');

8078: GOTO end_getcontact;
8079: end if;
8080: if (p_method is null) then
8081: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No METHOD');
8082: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_METHOD');
8083: FND_MSG_PUB.Add;
8084: l_return_status := FND_API.G_RET_STS_ERROR;
8085: GOTO end_getcontact;
8086: end if;

Line 8112: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_EMAIL');

8108: Fetch C_Get_CONTACT_EMAIL2 into l_email, l_primary;
8109:
8110: If ( C_GET_CONTACT_EMAIL2%NOTFOUND) Then
8111: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Customer NotFound');
8112: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_EMAIL');
8113: FND_MSG_PUB.Add;
8114: l_return_status := FND_API.G_RET_STS_ERROR;
8115: Close C_Get_CONTACT_EMAIL2;
8116: Close C_Get_CONTACT_EMAIL;

Line 8122: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_EMAIL');

8118: end if;
8119: --
8120: If ( l_email is null ) Then
8121: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - EmailAddress NotFound in C_GET_ORG_EMAIL');
8122: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_EMAIL');
8123: FND_MSG_PUB.Add;
8124: l_return_status := FND_API.G_RET_STS_ERROR;
8125: Close C_Get_CONTACT_EMAIL2;
8126: Close C_Get_CONTACT_EMAIL;

Line 8135: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_EMAIL');

8131: end if;
8132:
8133: If ( l_email is null ) Then
8134: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - EmailAddress is null');
8135: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_EMAIL');
8136: FND_MSG_PUB.Add;
8137: l_return_status := FND_API.G_RET_STS_ERROR;
8138: Close C_Get_CONTACT_EMAIL;
8139: GOTO end_getcontact;

Line 8163: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_FAX');

8159: Fetch C_Get_CONTACT_FAX2 into l_fax, l_primary;
8160:
8161: If ( C_GET_CONTACT_FAX2%NOTFOUND) Then
8162: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Customer NotFound');
8163: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_FAX');
8164: FND_MSG_PUB.Add;
8165: l_return_status := FND_API.G_RET_STS_ERROR;
8166: Close C_Get_CONTACT_FAX2;
8167: Close C_Get_CONTACT_FAX;

Line 8173: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_FAX');

8169: end if;
8170: --
8171: If ( l_fax is null ) Then
8172: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Fax NotFound in C_GET_CONTACT_FAX');
8173: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_FAX');
8174: FND_MSG_PUB.Add;
8175: l_return_status := FND_API.G_RET_STS_ERROR;
8176: Close C_Get_CONTACT_FAX2;
8177: Close C_Get_CONTACT_FAX;

Line 8186: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_FAX');

8182: end if;
8183:
8184: If ( l_fax is null ) Then
8185: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - FAX NotFound');
8186: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_FAX');
8187: FND_MSG_PUB.Add;
8188: l_return_status := FND_API.G_RET_STS_ERROR;
8189: Close C_Get_CONTACT_FAX;
8190: GOTO end_getcontact;