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.PVX_MISC_PVT dependencies on FND_MESSAGE

Line 152: FND_MESSAGE.set_name('PV', 'PV_MISC_NO_PROFILE_ID');

148:
149:
150: -- If partner_profile_id IS NULL, raise an error
151: IF l_admin_rec.partner_profile_id IS NULL THEN
152: FND_MESSAGE.set_name('PV', 'PV_MISC_NO_PROFILE_ID');
153: --FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_id) );
154: FND_MSG_PUB.add;
155: x_return_status := FND_API.g_ret_sts_error;
156: RAISE FND_API.g_exc_error;

Line 153: --FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_id) );

149:
150: -- If partner_profile_id IS NULL, raise an error
151: IF l_admin_rec.partner_profile_id IS NULL THEN
152: FND_MESSAGE.set_name('PV', 'PV_MISC_NO_PROFILE_ID');
153: --FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_id) );
154: FND_MSG_PUB.add;
155: x_return_status := FND_API.g_ret_sts_error;
156: RAISE FND_API.g_exc_error;
157: END IF;

Line 227: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_LOGD_RES_ID');

223: ,x_access_id => x_access_id
224: );
225:
226: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
227: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_LOGD_RES_ID');
228: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.logged_resource_id) );
229: FND_MSG_PUB.add;
230: END IF;
231:

Line 228: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.logged_resource_id) );

224: );
225:
226: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
227: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_LOGD_RES_ID');
228: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.logged_resource_id) );
229: FND_MSG_PUB.add;
230: END IF;
231:
232:

Line 255: FND_MESSAGE.set_name('PV', 'PV_NOT_VALID_USER');

251: -- bug no 1651872 Chandra Sekhar.C
252:
253: -- If user_id IS NULL, raise an error
254: IF l_user_id IS NULL THEN
255: FND_MESSAGE.set_name('PV', 'PV_NOT_VALID_USER');
256: FND_MESSAGE.set_token('ENTITY',l_source_name );
257: FND_MSG_PUB.add;
258: x_return_status := FND_API.g_ret_sts_error;
259: RAISE FND_API.g_exc_error;

Line 256: FND_MESSAGE.set_token('ENTITY',l_source_name );

252:
253: -- If user_id IS NULL, raise an error
254: IF l_user_id IS NULL THEN
255: FND_MESSAGE.set_name('PV', 'PV_NOT_VALID_USER');
256: FND_MESSAGE.set_token('ENTITY',l_source_name );
257: FND_MSG_PUB.add;
258: x_return_status := FND_API.g_ret_sts_error;
259: RAISE FND_API.g_exc_error;
260: END IF;

Line 316: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_CM_ID');

312: ,x_access_id => x_access_id
313: );
314:
315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
316: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_CM_ID');
317: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.cm_id) );
318: FND_MSG_PUB.add;
319: END IF;
320:

Line 317: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.cm_id) );

313: );
314:
315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
316: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_CM_ID');
317: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.cm_id) );
318: FND_MSG_PUB.add;
319: END IF;
320:
321:

Line 342: FND_MESSAGE.set_name('PV', 'PV_NOT_VALID_USER');

338: -- bug no. 1651872 Chandra Sekhar.C
339:
340: -- If user_id IS NULL, raise an error
341: IF l_user_id IS NULL THEN
342: FND_MESSAGE.set_name('PV', 'PV_NOT_VALID_USER');
343: FND_MESSAGE.set_token('ENTITY',l_source_name );
344: FND_MSG_PUB.add;
345: x_return_status := FND_API.g_ret_sts_error;
346: RAISE FND_API.g_exc_error;

Line 343: FND_MESSAGE.set_token('ENTITY',l_source_name );

339:
340: -- If user_id IS NULL, raise an error
341: IF l_user_id IS NULL THEN
342: FND_MESSAGE.set_name('PV', 'PV_NOT_VALID_USER');
343: FND_MESSAGE.set_token('ENTITY',l_source_name );
344: FND_MSG_PUB.add;
345: x_return_status := FND_API.g_ret_sts_error;
346: RAISE FND_API.g_exc_error;
347: END IF;

Line 401: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_REP_ID');

397: ,x_access_id => x_access_id
398: );
399:
400: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
401: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_REP_ID');
402: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.ph_support_rep) );
403: FND_MSG_PUB.add;
404: END IF;
405:

Line 402: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.ph_support_rep) );

398: );
399:
400: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
401: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_REP_ID');
402: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.ph_support_rep) );
403: FND_MSG_PUB.add;
404: END IF;
405:
406: IF x_return_status = FND_API.g_ret_sts_error THEN

Line 426: FND_MESSAGE.set_name('PV', 'PV_NOT_VALID_USER');

422: CLOSE c_resource_detail;
423:
424: -- If user_id IS NULL, raise an error
425: IF l_user_id IS NULL THEN
426: FND_MESSAGE.set_name('PV', 'PV_NOT_VALID_USER');
427: FND_MESSAGE.set_token('ENTITY',l_source_name );
428: FND_MSG_PUB.add;
429: x_return_status := FND_API.g_ret_sts_error;
430: RAISE FND_API.g_exc_error;

Line 427: FND_MESSAGE.set_token('ENTITY',l_source_name );

423:
424: -- If user_id IS NULL, raise an error
425: IF l_user_id IS NULL THEN
426: FND_MESSAGE.set_name('PV', 'PV_NOT_VALID_USER');
427: FND_MESSAGE.set_token('ENTITY',l_source_name );
428: FND_MSG_PUB.add;
429: x_return_status := FND_API.g_ret_sts_error;
430: RAISE FND_API.g_exc_error;
431: END IF;

Line 467: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_CMM_ID');

463: ,x_access_id => x_access_id
464: );
465:
466: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
467: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_CMM_ID');
468: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.cmm_id) );
469: FND_MSG_PUB.add;
470: END IF;
471:

Line 468: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.cmm_id) );

464: );
465:
466: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
467: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_CMM_ID');
468: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.cmm_id) );
469: FND_MSG_PUB.add;
470: END IF;
471:
472:

Line 723: FND_MESSAGE.set_name('PV', 'PV_MISC_NO_SOURCE_NAME');

719: -------------------------- create --------------------------
720: /*
721: -- If the source_name is null then error out
722: IF l_admin_rec.source_name IS NULL THEN
723: FND_MESSAGE.set_name('PV', 'PV_MISC_NO_SOURCE_NAME');
724: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.partner_id) );
725: FND_MSG_PUB.add;
726: RAISE FND_API.g_exc_error;
727: END IF;

Line 724: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.partner_id) );

720: /*
721: -- If the source_name is null then error out
722: IF l_admin_rec.source_name IS NULL THEN
723: FND_MESSAGE.set_name('PV', 'PV_MISC_NO_SOURCE_NAME');
724: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.partner_id) );
725: FND_MSG_PUB.add;
726: RAISE FND_API.g_exc_error;
727: END IF;
728: */

Line 848: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_RES_CREATION');

844: END IF;
845:
846:
847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
848: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_RES_CREATION');
849: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.partner_id) );
850: FND_MSG_PUB.add;
851: END IF;
852:

Line 849: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.partner_id) );

845:
846:
847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
848: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_RES_CREATION');
849: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.partner_id) );
850: FND_MSG_PUB.add;
851: END IF;
852:
853: IF x_return_status = FND_API.g_ret_sts_error THEN

Line 1009: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_ROLE_RELATE');

1005:
1006: );
1007:
1008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1009: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_ROLE_RELATE');
1010: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.role_resource_id));
1011: FND_MSG_PUB.add;
1012: END IF;
1013:

Line 1010: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.role_resource_id));

1006: );
1007:
1008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1009: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_ROLE_RELATE');
1010: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.role_resource_id));
1011: FND_MSG_PUB.add;
1012: END IF;
1013:
1014: IF x_return_status = FND_API.g_ret_sts_error THEN

Line 1178: FND_MESSAGE.set_name('PV', 'PV_DENY_INTERNAL_ORG_PROFILE');

1174: -- Fix for the bug # 2535467 begin
1175:
1176: IF c_party_name%NOTFOUND THEN
1177: CLOSE c_party_name;
1178: FND_MESSAGE.set_name('PV', 'PV_DENY_INTERNAL_ORG_PROFILE');
1179: FND_MSG_PUB.add;
1180: RAISE FND_API.g_exc_error;
1181: ELSE
1182: CLOSE c_party_name;

Line 1206: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_CREATE');

1202: );
1203: --DBMS_OUTPUT.PUT_LINE('x_group_id : '||TO_CHAR(x_group_id));
1204:
1205: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1206: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_CREATE');
1207: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.partner_id));
1208: FND_MSG_PUB.add;
1209: END IF;
1210:

Line 1207: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.partner_id));

1203: --DBMS_OUTPUT.PUT_LINE('x_group_id : '||TO_CHAR(x_group_id));
1204:
1205: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1206: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_CREATE');
1207: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.partner_id));
1208: FND_MSG_PUB.add;
1209: END IF;
1210:
1211: IF x_return_status = FND_API.g_ret_sts_error THEN

Line 1240: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_USAGE');

1236:
1237: --DBMS_OUTPUT.PUT_LINE('x_group_usage_id : '||TO_CHAR(x_group_usage_id));
1238:
1239: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1240: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_USAGE');
1241: FND_MESSAGE.set_token('ID',to_char(x_group_id));
1242: FND_MSG_PUB.add;
1243: END IF;
1244:

Line 1241: FND_MESSAGE.set_token('ID',to_char(x_group_id));

1237: --DBMS_OUTPUT.PUT_LINE('x_group_usage_id : '||TO_CHAR(x_group_usage_id));
1238:
1239: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1240: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_USAGE');
1241: FND_MESSAGE.set_token('ID',to_char(x_group_id));
1242: FND_MSG_PUB.add;
1243: END IF;
1244:
1245: IF x_return_status = FND_API.g_ret_sts_error THEN

Line 1275: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_MEMBER');

1271:
1272: --DBMS_OUTPUT.PUT_LINE('x_group_member_id : '||TO_CHAR(x_group_member_id));
1273:
1274: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1275: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_MEMBER');
1276: FND_MESSAGE.set_token('ID1',to_char(l_admin_rec.role_resource_id));
1277: FND_MESSAGE.set_token('ID2',to_char(x_group_id));
1278: FND_MSG_PUB.add;
1279: END IF;

Line 1276: FND_MESSAGE.set_token('ID1',to_char(l_admin_rec.role_resource_id));

1272: --DBMS_OUTPUT.PUT_LINE('x_group_member_id : '||TO_CHAR(x_group_member_id));
1273:
1274: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1275: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_MEMBER');
1276: FND_MESSAGE.set_token('ID1',to_char(l_admin_rec.role_resource_id));
1277: FND_MESSAGE.set_token('ID2',to_char(x_group_id));
1278: FND_MSG_PUB.add;
1279: END IF;
1280:

Line 1277: FND_MESSAGE.set_token('ID2',to_char(x_group_id));

1273:
1274: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1275: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_MEMBER');
1276: FND_MESSAGE.set_token('ID1',to_char(l_admin_rec.role_resource_id));
1277: FND_MESSAGE.set_token('ID2',to_char(x_group_id));
1278: FND_MSG_PUB.add;
1279: END IF;
1280:
1281: IF x_return_status = FND_API.g_ret_sts_error THEN

Line 1430: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_MEMBER');

1426: );
1427:
1428:
1429: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1430: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_MEMBER');
1431: FND_MESSAGE.set_token('ID1',to_char(l_admin_rec.role_resource_id));
1432: FND_MESSAGE.set_token('ID2',to_char(l_admin_rec.group_id));
1433: FND_MSG_PUB.add;
1434: END IF;

Line 1431: FND_MESSAGE.set_token('ID1',to_char(l_admin_rec.role_resource_id));

1427:
1428:
1429: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1430: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_MEMBER');
1431: FND_MESSAGE.set_token('ID1',to_char(l_admin_rec.role_resource_id));
1432: FND_MESSAGE.set_token('ID2',to_char(l_admin_rec.group_id));
1433: FND_MSG_PUB.add;
1434: END IF;
1435:

Line 1432: FND_MESSAGE.set_token('ID2',to_char(l_admin_rec.group_id));

1428:
1429: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1430: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_MEMBER');
1431: FND_MESSAGE.set_token('ID1',to_char(l_admin_rec.role_resource_id));
1432: FND_MESSAGE.set_token('ID2',to_char(l_admin_rec.group_id));
1433: FND_MSG_PUB.add;
1434: END IF;
1435:
1436: IF x_return_status = FND_API.g_ret_sts_error THEN

Line 1568: FND_MESSAGE.set_name('PV', 'PV_FND_NO_USER_NAME');

1564:
1565:
1566: -- If user_name IS NULL, raise an error
1567: IF l_fnd_rec.user_name IS NULL THEN
1568: FND_MESSAGE.set_name('PV', 'PV_FND_NO_USER_NAME');
1569: FND_MSG_PUB.add;
1570: x_return_status := FND_API.g_ret_sts_error;
1571: RAISE FND_API.g_exc_error;
1572: END IF;

Line 1585: FND_MESSAGE.set_name('PV', 'PV_ERROR_UPDATE_USER');

1581: ,X_EMAIL_ADDRESS => l_fnd_rec.email_address
1582: );
1583:
1584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1585: FND_MESSAGE.set_name('PV', 'PV_ERROR_UPDATE_USER');
1586: FND_MSG_PUB.add;
1587: END IF;
1588:
1589:

Line 1871: FND_MESSAGE.SET_NAME( application => 'PV'

1867: l_partner_number VARCHAR2(30);
1868:
1869: BEGIN
1870:
1871: FND_MESSAGE.SET_NAME( application => 'PV'
1872: ,name => 'PV_PARTNER_STATUS_BATCH_START');
1873:
1874: FND_MESSAGE.SET_TOKEN( token => 'P_DATE_TIME'
1875: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );

Line 1874: FND_MESSAGE.SET_TOKEN( token => 'P_DATE_TIME'

1870:
1871: FND_MESSAGE.SET_NAME( application => 'PV'
1872: ,name => 'PV_PARTNER_STATUS_BATCH_START');
1873:
1874: FND_MESSAGE.SET_TOKEN( token => 'P_DATE_TIME'
1875: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
1876:
1877: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
1878: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

Line 1877: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );

1873:
1874: FND_MESSAGE.SET_TOKEN( token => 'P_DATE_TIME'
1875: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
1876:
1877: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
1878: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
1879:
1880:
1881: l_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1992: FND_MESSAGE.SET_NAME( application => 'PV'

1988: OPEN c_party_name (l_partners_rec.partner_party_id);
1989: FETCH c_party_name INTO l_partner_name, l_partner_number;
1990: CLOSE c_party_name;
1991:
1992: FND_MESSAGE.SET_NAME( application => 'PV'
1993: ,name => 'PV_PARTNER_STATUS_ERR_PARTNER');
1994: FND_MESSAGE.SET_TOKEN( token => 'PARTNER'
1995: ,value => l_partner_name || ' (' || l_partner_number || ')');
1996: l_message := FND_MESSAGE.get;

Line 1994: FND_MESSAGE.SET_TOKEN( token => 'PARTNER'

1990: CLOSE c_party_name;
1991:
1992: FND_MESSAGE.SET_NAME( application => 'PV'
1993: ,name => 'PV_PARTNER_STATUS_ERR_PARTNER');
1994: FND_MESSAGE.SET_TOKEN( token => 'PARTNER'
1995: ,value => l_partner_name || ' (' || l_partner_number || ')');
1996: l_message := FND_MESSAGE.get;
1997:
1998: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );

Line 1996: l_message := FND_MESSAGE.get;

1992: FND_MESSAGE.SET_NAME( application => 'PV'
1993: ,name => 'PV_PARTNER_STATUS_ERR_PARTNER');
1994: FND_MESSAGE.SET_TOKEN( token => 'PARTNER'
1995: ,value => l_partner_name || ' (' || l_partner_number || ')');
1996: l_message := FND_MESSAGE.get;
1997:
1998: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
1999: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2000:

Line 2020: FND_MESSAGE.SET_NAME( application => 'PV'

2016: COMMIT;
2017:
2018: IF l_total_partners = l_error_partners THEN
2019:
2020: FND_MESSAGE.SET_NAME( application => 'PV'
2021: ,name => 'PV_PARTNER_STATUS_COMPLET_FAIL');
2022: FND_MSG_PUB.ADD;
2023: l_message := FND_MESSAGE.get;
2024:

Line 2023: l_message := FND_MESSAGE.get;

2019:
2020: FND_MESSAGE.SET_NAME( application => 'PV'
2021: ,name => 'PV_PARTNER_STATUS_COMPLET_FAIL');
2022: FND_MSG_PUB.ADD;
2023: l_message := FND_MESSAGE.get;
2024:
2025: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
2026: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2027:

Line 2033: FND_MESSAGE.SET_NAME( application => 'PV'

2029: ERRBUF := l_message;
2030:
2031: ELSIF l_total_partners <> l_error_partners AND l_error_partners <> 0 THEN
2032:
2033: FND_MESSAGE.SET_NAME( application => 'PV'
2034: ,name => 'PV_PARTNER_STATUS_PARTIAL_FAIL');
2035: FND_MESSAGE.SET_TOKEN( token => 'TOTAL_PARTNERS'
2036: ,value => l_total_partners);
2037: FND_MESSAGE.SET_TOKEN( token => 'ERROR_PARTNERS'

Line 2035: FND_MESSAGE.SET_TOKEN( token => 'TOTAL_PARTNERS'

2031: ELSIF l_total_partners <> l_error_partners AND l_error_partners <> 0 THEN
2032:
2033: FND_MESSAGE.SET_NAME( application => 'PV'
2034: ,name => 'PV_PARTNER_STATUS_PARTIAL_FAIL');
2035: FND_MESSAGE.SET_TOKEN( token => 'TOTAL_PARTNERS'
2036: ,value => l_total_partners);
2037: FND_MESSAGE.SET_TOKEN( token => 'ERROR_PARTNERS'
2038: ,value => l_error_partners);
2039: l_message := FND_MESSAGE.get;

Line 2037: FND_MESSAGE.SET_TOKEN( token => 'ERROR_PARTNERS'

2033: FND_MESSAGE.SET_NAME( application => 'PV'
2034: ,name => 'PV_PARTNER_STATUS_PARTIAL_FAIL');
2035: FND_MESSAGE.SET_TOKEN( token => 'TOTAL_PARTNERS'
2036: ,value => l_total_partners);
2037: FND_MESSAGE.SET_TOKEN( token => 'ERROR_PARTNERS'
2038: ,value => l_error_partners);
2039: l_message := FND_MESSAGE.get;
2040:
2041: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );

Line 2039: l_message := FND_MESSAGE.get;

2035: FND_MESSAGE.SET_TOKEN( token => 'TOTAL_PARTNERS'
2036: ,value => l_total_partners);
2037: FND_MESSAGE.SET_TOKEN( token => 'ERROR_PARTNERS'
2038: ,value => l_error_partners);
2039: l_message := FND_MESSAGE.get;
2040:
2041: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
2042: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2043:

Line 2048: FND_MESSAGE.SET_NAME( application => 'PV'

2044: RETCODE := 1;
2045: ERRBUF := l_message;
2046:
2047: ELSIF l_error_partners = 0 THEN
2048: FND_MESSAGE.SET_NAME( application => 'PV'
2049: ,name => 'PV_PARTNER_STATUS_SUCCESS');
2050: l_message := FND_MESSAGE.get;
2051:
2052: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );

Line 2050: l_message := FND_MESSAGE.get;

2046:
2047: ELSIF l_error_partners = 0 THEN
2048: FND_MESSAGE.SET_NAME( application => 'PV'
2049: ,name => 'PV_PARTNER_STATUS_SUCCESS');
2050: l_message := FND_MESSAGE.get;
2051:
2052: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
2053: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2054:

Line 2059: FND_MESSAGE.SET_NAME( application => 'PV'

2055: RETCODE := 0;
2056: ERRBUF := l_message;
2057: END IF;
2058:
2059: FND_MESSAGE.SET_NAME( application => 'PV'
2060: ,name => 'PV_PARTNER_STATUS_BATCH_END');
2061:
2062: FND_MESSAGE.SET_TOKEN( token => 'P_DATE_TIME'
2063: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );

Line 2062: FND_MESSAGE.SET_TOKEN( token => 'P_DATE_TIME'

2058:
2059: FND_MESSAGE.SET_NAME( application => 'PV'
2060: ,name => 'PV_PARTNER_STATUS_BATCH_END');
2061:
2062: FND_MESSAGE.SET_TOKEN( token => 'P_DATE_TIME'
2063: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2064:
2065: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
2066: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );

Line 2065: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );

2061:
2062: FND_MESSAGE.SET_TOKEN( token => 'P_DATE_TIME'
2063: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2064:
2065: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
2066: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2067:
2068: EXCEPTION
2069: WHEN OTHERS THEN

Line 2071: FND_MESSAGE.SET_NAME( application => 'PV'

2067:
2068: EXCEPTION
2069: WHEN OTHERS THEN
2070: ROLLBACK;
2071: FND_MESSAGE.SET_NAME( application => 'PV'
2072: ,name => 'PV_UNKNOWN_ERROR');
2073: FND_MESSAGE.SET_TOKEN( token => 'TEXT'
2074: ,value => 'Database Error:'||sqlcode||' '||sqlerrm);
2075: FND_MSG_PUB.ADD;

Line 2073: FND_MESSAGE.SET_TOKEN( token => 'TEXT'

2069: WHEN OTHERS THEN
2070: ROLLBACK;
2071: FND_MESSAGE.SET_NAME( application => 'PV'
2072: ,name => 'PV_UNKNOWN_ERROR');
2073: FND_MESSAGE.SET_TOKEN( token => 'TEXT'
2074: ,value => 'Database Error:'||sqlcode||' '||sqlerrm);
2075: FND_MSG_PUB.ADD;
2076: l_message := FND_MESSAGE.get;
2077:

Line 2076: l_message := FND_MESSAGE.get;

2072: ,name => 'PV_UNKNOWN_ERROR');
2073: FND_MESSAGE.SET_TOKEN( token => 'TEXT'
2074: ,value => 'Database Error:'||sqlcode||' '||sqlerrm);
2075: FND_MSG_PUB.ADD;
2076: l_message := FND_MESSAGE.get;
2077:
2078: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
2079: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2080:

Line 2081: FND_MESSAGE.SET_NAME( application => 'PV'

2077:
2078: FND_FILE.PUT_LINE( FND_FILE.LOG, l_message );
2079: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2080:
2081: FND_MESSAGE.SET_NAME( application => 'PV'
2082: ,name => 'PV_UNKNOWN_ERROR');
2083: RETCODE := 1;
2084: ERRBUF := fnd_message.get;
2085:

Line 2084: ERRBUF := fnd_message.get;

2080:
2081: FND_MESSAGE.SET_NAME( application => 'PV'
2082: ,name => 'PV_UNKNOWN_ERROR');
2083: RETCODE := 1;
2084: ERRBUF := fnd_message.get;
2085:
2086: END Update_Partner_Status;
2087:
2088: -------------------------------------------------------------------

Line 2179: FND_MESSAGE.SET_NAME(

2175: l_error_partners NUMBER;
2176:
2177: BEGIN
2178:
2179: FND_MESSAGE.SET_NAME(
2180: application => 'PV'
2181: ,name => 'PV_CR_CUST_ACCT_BATCH_START');
2182:
2183: FND_MESSAGE.SET_TOKEN(

Line 2183: FND_MESSAGE.SET_TOKEN(

2179: FND_MESSAGE.SET_NAME(
2180: application => 'PV'
2181: ,name => 'PV_CR_CUST_ACCT_BATCH_START');
2182:
2183: FND_MESSAGE.SET_TOKEN(
2184: token => 'P_DATE_TIME'
2185: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2186:
2187: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );

Line 2187: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );

2183: FND_MESSAGE.SET_TOKEN(
2184: token => 'P_DATE_TIME'
2185: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2186:
2187: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
2188: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2189:
2190: /** Create a TCA account for partners if it does not exist **/
2191: account_rec.Created_by_Module := 'TCA_V2_API';

Line 2284: FND_MESSAGE.SET_NAME(

2280: exit when c_get_partner_wo_accounts%notfound;
2281: END LOOP; /* FETCH c_get_partner_wo_accounts bulk collect */
2282: CLOSE c_get_partner_wo_accounts;
2283:
2284: FND_MESSAGE.SET_NAME(
2285: application => 'PV'
2286: ,name => 'PV_CR_CUST_ACCT_BATCH_END');
2287:
2288: FND_MESSAGE.SET_TOKEN(

Line 2288: FND_MESSAGE.SET_TOKEN(

2284: FND_MESSAGE.SET_NAME(
2285: application => 'PV'
2286: ,name => 'PV_CR_CUST_ACCT_BATCH_END');
2287:
2288: FND_MESSAGE.SET_TOKEN(
2289: token => 'P_DATE_TIME'
2290: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2291: --------------------------------------------------------------------------
2292:

Line 2293: FND_MESSAGE.SET_NAME(

2289: token => 'P_DATE_TIME'
2290: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2291: --------------------------------------------------------------------------
2292:
2293: FND_MESSAGE.SET_NAME(
2294: application => 'PV'
2295: ,name => 'PV_AS_ACCT_TO_CNTCT_BTCH_START');
2296:
2297: FND_MESSAGE.SET_TOKEN(

Line 2297: FND_MESSAGE.SET_TOKEN(

2293: FND_MESSAGE.SET_NAME(
2294: application => 'PV'
2295: ,name => 'PV_AS_ACCT_TO_CNTCT_BTCH_START');
2296:
2297: FND_MESSAGE.SET_TOKEN(
2298: token => 'P_DATE_TIME'
2299: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2300:
2301: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );

Line 2301: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );

2297: FND_MESSAGE.SET_TOKEN(
2298: token => 'P_DATE_TIME'
2299: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2300:
2301: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
2302: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
2303:
2304: /** Assign an account to contact **/
2305: open c_get_prtnrcntct_wo_role;

Line 2377: FND_MESSAGE.SET_NAME(

2373: exit when c_get_prtnrcntct_wo_role%notfound;
2374: end loop;
2375: Close c_get_prtnrcntct_wo_role;
2376:
2377: FND_MESSAGE.SET_NAME(
2378: application => 'PV'
2379: ,name => 'PV_AS_ACCT_TO_CNTCT_BTCH_END');
2380:
2381: FND_MESSAGE.SET_TOKEN(

Line 2381: FND_MESSAGE.SET_TOKEN(

2377: FND_MESSAGE.SET_NAME(
2378: application => 'PV'
2379: ,name => 'PV_AS_ACCT_TO_CNTCT_BTCH_END');
2380:
2381: FND_MESSAGE.SET_TOKEN(
2382: token => 'P_DATE_TIME'
2383: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
2384:
2385: END Cr_As_Accts_With_Partner_User;