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.PV_CONTACT_USER_BATCH_PUB dependencies on FND_MSG_PUB

Line 4: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

1: PACKAGE BODY PV_CONTACT_USER_BATCH_PUB AS
2: /* $Header: pvxpldcb.pls 120.24 2006/02/12 19:48 svnathan noship $ */
3:
4: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8:

Line 5: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1: PACKAGE BODY PV_CONTACT_USER_BATCH_PUB AS
2: /* $Header: pvxpldcb.pls 120.24 2006/02/12 19:48 svnathan noship $ */
3:
4: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8:
9:

Line 6: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

2: /* $Header: pvxpldcb.pls 120.24 2006/02/12 19:48 svnathan noship $ */
3:
4: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8:
9:
10: L_LOG_FILE utl_file.file_type;

Line 126: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

122:
123:
124: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
125: /*FOR l_msg_index IN 1..l_msg_count LOOP
126: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
127: -- dbms_output.put_line(fnd_message.get);
128: l_log_count:= l_log_count + 1;
129: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
130: END LOOP;

Line 134: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_count));

130: END LOOP;
131: */
132:
133: l_log_count:= l_log_count + 1;
134: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_count));
135: x_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
136:
137: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

Line 663: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

659:
660:
661: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
662: /* FOR l_msg_index IN 1..l_msg_count LOOP
663: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
664: -- dbms_output.put_line(fnd_message.get);
665: l_log_count:= l_log_count + 1;
666: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
667: END LOOP;

Line 671: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_count));

667: END LOOP;
668: */
669:
670: l_log_count:= l_log_count + 1;
671: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_count));
672: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
673:
674:
675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 724: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

720: l_contact_create_ok := 'FALSE';
721: x_contact_output_rec.return_status:='ERROR';
722: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
723: FOR l_msg_index IN 1..l_msg_count LOOP
724: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
725: -- dbms_output.put_line(fnd_message.get);
726: l_log_count:= l_log_count + 1;
727: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
728: END LOOP;

Line 763: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

759: l_contact_create_ok := 'FALSE';
760: x_contact_output_rec.return_status:='ERROR';
761: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
762: FOR l_msg_index IN 1..l_msg_count LOOP
763: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
764: -- dbms_output.put_line(fnd_message.get);
765: l_log_count:= l_log_count + 1;
766: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
767: END LOOP;

Line 820: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

816: l_contact_create_ok := 'FALSE';
817: x_contact_output_rec.return_status:='ERROR';
818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
819: FOR l_msg_index IN 1..l_msg_count LOOP
820: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
821: -- -- dbms_output.put_line('Printing first time' || fnd_message.get);
822: l_log_count:= l_log_count + 1;
823: -- l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
824: l_log_msg(l_log_count):=fnd_message.get;

Line 872: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

868: l_contact_create_ok := 'FALSE';
869: x_contact_output_rec.return_status:='ERROR';
870: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
871: FOR l_msg_index IN 1..l_msg_count LOOP
872: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
873: -- dbms_output.put_line(fnd_message.get);
874: l_log_count:= l_log_count + 1;
875: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
876: END LOOP;

Line 969: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

965: l_contact_create_ok := 'FALSE';
966: x_contact_output_rec.return_status:='ERROR';
967: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
968: FOR l_msg_index IN 1..l_msg_count LOOP
969: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
970: -- dbms_output.put_line(fnd_message.get);
971: l_log_count:= l_log_count + 1;
972: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
973: END LOOP;

Line 1017: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

1013: l_contact_create_ok := 'FALSE';
1014: x_contact_output_rec.return_status:='ERROR';
1015: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1016: FOR l_msg_index IN 1..l_msg_count LOOP
1017: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
1018: -- dbms_output.put_line(fnd_message.get);
1019: l_log_count:= l_log_count + 1;
1020: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1021: END LOOP;

Line 1249: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

1245: l_contact_create_ok := 'FALSE';
1246: x_contact_output_rec.return_status:='ERROR';
1247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1248: FOR l_msg_index IN 1..l_msg_count LOOP
1249: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
1250: -- dbms_output.put_line(fnd_message.get);
1251: l_log_count:= l_log_count + 1;
1252: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1253: END LOOP;

Line 1523: fnd_msg_pub.ADD;

1519:
1520:
1521: if l_contact_rel_id is null then
1522: fnd_message.SET_NAME ('PV', 'PV_CONTACT_ID_INVALID');
1523: fnd_msg_pub.ADD;
1524: raise FND_API.G_EXC_ERROR;
1525: END IF;
1526:
1527:

Line 1535: fnd_msg_pub.ADD;

1531:
1532:
1533: if l_contact_party_id is null then
1534: fnd_message.SET_NAME ('PV', 'PV_CONTACT_ID_INVALID');
1535: fnd_msg_pub.ADD;
1536: raise FND_API.G_EXC_ERROR;
1537:
1538: END IF;
1539:

Line 1544: fnd_msg_pub.ADD;

1540:
1541:
1542: if l_user_name is null then
1543: fnd_message.SET_NAME ('PV', 'PV_USER_NAME_MISSING');
1544: fnd_msg_pub.ADD;
1545: raise FND_API.G_EXC_ERROR;
1546:
1547: END IF;
1548:

Line 1557: fnd_msg_pub.ADD;

1553: /**************** CHECK FOR SSO ************************************************************************/
1554: l_sso_enabled := fnd_profile.value('APPS_SSO_USER_CREATE_UPDATE');
1555: if l_sso_enabled = 'N' OR l_sso_enabled = 'FTTT' OR l_sso_enabled = 'FFFF' then
1556: fnd_message.set_name('PV', 'PV_SSO_CREATE_USER_NOT_ALLOWED');
1557: fnd_msg_pub.ADD;
1558: raise FND_API.G_EXC_ERROR;
1559: end if;
1560:
1561: -- dbms_output.put_line('after sso check ');

Line 1580: fnd_msg_pub.ADD;

1576:
1577:
1578: if l_relationship_code is null or l_relationship_code <> 'EMPLOYEE_OF' then
1579: fnd_message.SET_NAME ('PV', 'PV_NOT_EMPLOYEE_REL');
1580: fnd_msg_pub.ADD;
1581: RAISE FND_API.G_EXC_ERROR;
1582: END IF;
1583:
1584: -- dbms_output.put_line('After relationship check');

Line 1597: fnd_msg_pub.ADD;

1593: -- dbms_output.put_line('before party status check');
1594:
1595: if l_party_status is null or l_party_status <> 'A' then
1596: fnd_message.SET_NAME ('PV', 'PV_CONTACT_NOT_ACTIVE');
1597: fnd_msg_pub.ADD;
1598: RAISE FND_API.G_EXC_ERROR;
1599:
1600: END IF;
1601:

Line 1677: FND_MSG_PUB.Add;

1673: RAISE FND_API.G_EXC_ERROR;
1674: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1675: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1676: FND_MESSAGE.SET_TOKEN('API_NAME', 'JTF_UM_PASSWORD_PVT.generate_password ');
1677: FND_MSG_PUB.Add;
1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1679: END IF;
1680: END IF;
1681:

Line 1754: FND_MSG_PUB.Add;

1750: RAISE FND_API.G_EXC_ERROR;
1751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1753: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_USER_MGMT_PVT.register_partner_user ');
1754: FND_MSG_PUB.Add;
1755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1756: END IF;
1757: END IF;
1758:

Line 1792: FND_MSG_PUB.Add;

1788: RAISE FND_API.G_EXC_ERROR;
1789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1790: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1791: FND_MESSAGE.SET_TOKEN('API_NAME', 'pv_user_resp_pvt.assign_resp');
1792: FND_MSG_PUB.Add;
1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1794: END IF;
1795: END IF;
1796:

Line 1847: FND_MSG_PUB.Count_And_Get (

1843: x_return_status := FND_API.G_RET_STS_ERROR;
1844: x_msg_data:= l_msg_data;
1845: x_msg_count:= l_msg_count;
1846: -- Standard call to get message count and if count=1, get the message
1847: FND_MSG_PUB.Count_And_Get (
1848: p_encoded => FND_API.G_FALSE,
1849: p_count => x_msg_count,
1850: p_data => x_msg_data
1851: );

Line 1854: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1850: p_data => x_msg_data
1851: );
1852:
1853: -- Debug Message
1854: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1855: hz_utility_v2pub.debug_return_messages (
1856: x_msg_count, x_msg_data, 'ERROR');
1857: hz_utility_v2pub.debug('user_create (-)');
1858: END IF;

Line 1865: FND_MSG_PUB.Count_And_Get (

1861: ROLLBACK TO user_create_pvt;
1862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1863:
1864: -- Standard call to get message count and if count=1, get the message
1865: FND_MSG_PUB.Count_And_Get (
1866: p_encoded => FND_API.G_FALSE,
1867: p_count => x_msg_count,
1868: p_data => x_msg_data
1869: );

Line 1872: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1868: p_data => x_msg_data
1869: );
1870:
1871: -- Debug Message
1872: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1873: hz_utility_v2pub.debug_return_messages (
1874: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1875: hz_utility_v2pub.debug('user_create (-)');
1876: END IF;

Line 1881: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1877:
1878: WHEN OTHERS THEN
1879: ROLLBACK TO user_create_pvt;
1880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1881: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1882: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1883: END IF;
1884:
1885: -- Standard call to get message count and if count=1, get the message

Line 1882: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1878: WHEN OTHERS THEN
1879: ROLLBACK TO user_create_pvt;
1880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1881: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1882: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1883: END IF;
1884:
1885: -- Standard call to get message count and if count=1, get the message
1886: FND_MSG_PUB.Count_And_Get (

Line 1886: FND_MSG_PUB.Count_And_Get (

1882: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1883: END IF;
1884:
1885: -- Standard call to get message count and if count=1, get the message
1886: FND_MSG_PUB.Count_And_Get (
1887: p_encoded => FND_API.G_FALSE,
1888: p_count => x_msg_count,
1889: p_data => x_msg_data );
1890:

Line 1892: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1888: p_count => x_msg_count,
1889: p_data => x_msg_data );
1890:
1891: -- Debug Message
1892: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1893: hz_utility_v2pub.debug_return_messages (
1894: x_msg_count, x_msg_data, 'SQL ERROR');
1895: hz_utility_v2pub.debug('user_create (-)');
1896: END IF;

Line 2125: fnd_msg_pub.ADD;

2121: -- dbms_output.put_line('l_contact_rel_id ' || l_contact_rel_id);
2122:
2123: if l_contact_rel_id is null then
2124: fnd_message.SET_NAME ('PV', 'PV_CONTACT_ID_INVALID');
2125: fnd_msg_pub.ADD;
2126: raise FND_API.G_EXC_ERROR;
2127: END IF;
2128:
2129:

Line 2137: fnd_msg_pub.ADD;

2133:
2134:
2135: if l_contact_party_id is null then
2136: fnd_message.SET_NAME ('PV', 'PV_CONTACT_ID_INVALID');
2137: fnd_msg_pub.ADD;
2138: raise FND_API.G_EXC_ERROR;
2139:
2140: END IF;
2141:

Line 2146: fnd_msg_pub.ADD;

2142:
2143:
2144: if l_user_name is null then
2145: fnd_message.SET_NAME ('PV', 'PV_USER_NAME_MISSING');
2146: fnd_msg_pub.ADD;
2147: raise FND_API.G_EXC_ERROR;
2148:
2149: END IF;
2150:

Line 2159: fnd_msg_pub.ADD;

2155: /**************** CHECK FOR SSO ************************************************************************/
2156: l_sso_enabled := fnd_profile.value('APPS_SSO_USER_CREATE_UPDATE');
2157: if l_sso_enabled = 'N' OR l_sso_enabled = 'FTTT' OR l_sso_enabled = 'FFFF' then
2158: fnd_message.set_name('PV', 'PV_SSO_CREATE_USER_NOT_ALLOWED');
2159: fnd_msg_pub.ADD;
2160: raise FND_API.G_EXC_ERROR;
2161: end if;
2162:
2163: -- dbms_output.put_line('after sso check ');

Line 2178: fnd_msg_pub.ADD;

2174:
2175:
2176: if l_relationship_code is null or l_relationship_code <> 'EMPLOYEE_OF' then
2177: fnd_message.SET_NAME ('PV', 'PV_NOT_EMPLOYEE_REL');
2178: fnd_msg_pub.ADD;
2179: RAISE FND_API.G_EXC_ERROR;
2180: END IF;
2181:
2182: -- dbms_output.put_line('After relationship check');

Line 2195: fnd_msg_pub.ADD;

2191: -- dbms_output.put_line('before party status check');
2192:
2193: if l_party_status is null or l_party_status <> 'A' then
2194: fnd_message.SET_NAME ('PV', 'PV_CONTACT_NOT_ACTIVE');
2195: fnd_msg_pub.ADD;
2196: RAISE FND_API.G_EXC_ERROR;
2197:
2198: END IF;
2199:

Line 2284: FND_MSG_PUB.Add;

2280: RAISE FND_API.G_EXC_ERROR;
2281: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2282: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2283: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_USER_MGMT_PVT.register_partner_user ');
2284: FND_MSG_PUB.Add;
2285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2286: END IF;
2287: END IF;
2288:

Line 2320: FND_MSG_PUB.Add;

2316: RAISE FND_API.G_EXC_ERROR;
2317: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2318: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2319: FND_MESSAGE.SET_TOKEN('API_NAME', 'pv_user_resp_pvt.assign_resp');
2320: FND_MSG_PUB.Add;
2321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2322: END IF;
2323: END IF;
2324:

Line 2376: FND_MSG_PUB.Count_And_Get (

2372: x_return_status := FND_API.G_RET_STS_ERROR;
2373: x_msg_data:= l_msg_data;
2374: x_msg_count:= l_msg_count;
2375: -- Standard call to get message count and if count=1, get the message
2376: FND_MSG_PUB.Count_And_Get (
2377: p_encoded => FND_API.G_FALSE,
2378: p_count => x_msg_count,
2379: p_data => x_msg_data
2380: );

Line 2383: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2379: p_data => x_msg_data
2380: );
2381:
2382: -- Debug Message
2383: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2384: hz_utility_v2pub.debug_return_messages (
2385: x_msg_count, x_msg_data, 'ERROR');
2386: hz_utility_v2pub.debug('user_update (-)');
2387: END IF;

Line 2394: FND_MSG_PUB.Count_And_Get (

2390: ROLLBACK TO user_update_pvt;
2391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2392:
2393: -- Standard call to get message count and if count=1, get the message
2394: FND_MSG_PUB.Count_And_Get (
2395: p_encoded => FND_API.G_FALSE,
2396: p_count => x_msg_count,
2397: p_data => x_msg_data
2398: );

Line 2401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2397: p_data => x_msg_data
2398: );
2399:
2400: -- Debug Message
2401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2402: hz_utility_v2pub.debug_return_messages (
2403: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
2404: hz_utility_v2pub.debug('user_update (-)');
2405: END IF;

Line 2410: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2406:
2407: WHEN OTHERS THEN
2408: ROLLBACK TO user_update_pvt;
2409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2410: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2411: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2412: END IF;
2413:
2414: -- Standard call to get message count and if count=1, get the message

Line 2411: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2407: WHEN OTHERS THEN
2408: ROLLBACK TO user_update_pvt;
2409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2410: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2411: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2412: END IF;
2413:
2414: -- Standard call to get message count and if count=1, get the message
2415: FND_MSG_PUB.Count_And_Get (

Line 2415: FND_MSG_PUB.Count_And_Get (

2411: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2412: END IF;
2413:
2414: -- Standard call to get message count and if count=1, get the message
2415: FND_MSG_PUB.Count_And_Get (
2416: p_encoded => FND_API.G_FALSE,
2417: p_count => x_msg_count,
2418: p_data => x_msg_data );
2419:

Line 2421: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2417: p_count => x_msg_count,
2418: p_data => x_msg_data );
2419:
2420: -- Debug Message
2421: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2422: hz_utility_v2pub.debug_return_messages (
2423: x_msg_count, x_msg_data, 'SQL ERROR');
2424: hz_utility_v2pub.debug('user_update (-)');
2425: END IF;

Line 2705: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

2701:
2702:
2703: ROLLBACK;
2704: /* utl_file.put_line(L_LOG_FILE,SQLERRM);
2705: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2706: utl_file.put_line(L_LOG_FILE,Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,1000));
2707: END LOOP;
2708: utl_file.fclose(l_log_file);
2709: */

Line 2706: utl_file.put_line(L_LOG_FILE,Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,1000));

2702:
2703: ROLLBACK;
2704: /* utl_file.put_line(L_LOG_FILE,SQLERRM);
2705: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2706: utl_file.put_line(L_LOG_FILE,Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,1000));
2707: END LOOP;
2708: utl_file.fclose(l_log_file);
2709: */
2710:

Line 2712: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2708: utl_file.fclose(l_log_file);
2709: */
2710:
2711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2712: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2714: END IF;
2715:
2716: -- Standard call to get message count and if count=1, get the message

Line 2713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2709: */
2710:
2711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2712: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2714: END IF;
2715:
2716: -- Standard call to get message count and if count=1, get the message
2717: FND_MSG_PUB.Count_And_Get (

Line 2717: FND_MSG_PUB.Count_And_Get (

2713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2714: END IF;
2715:
2716: -- Standard call to get message count and if count=1, get the message
2717: FND_MSG_PUB.Count_And_Get (
2718: p_encoded => FND_API.G_FALSE,
2719: p_count => x_msg_count,
2720: p_data => x_msg_data );
2721:

Line 2723: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2719: p_count => x_msg_count,
2720: p_data => x_msg_data );
2721:
2722: -- Debug Message
2723: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2724: hz_utility_v2pub.debug_return_messages (
2725: x_msg_count, x_msg_data, 'SQL ERROR');
2726: hz_utility_v2pub.debug('Load_contacts (-)');
2727: END IF;