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

Line 58: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

54:
55: -- Sub-Program unit declarations
56: -- Copy products from promotion,campaign,media_mix,channels - all activities
57:
58: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
59: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
60: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
61:
62: PROCEDURE copy_act_prod (

Line 59: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

55: -- Sub-Program unit declarations
56: -- Copy products from promotion,campaign,media_mix,channels - all activities
57:
58: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
59: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
60: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
61:
62: PROCEDURE copy_act_prod (
63: p_src_act_type IN VARCHAR2,

Line 60: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

56: -- Copy products from promotion,campaign,media_mix,channels - all activities
57:
58: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
59: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
60: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
61:
62: PROCEDURE copy_act_prod (
63: p_src_act_type IN VARCHAR2,
64: p_new_act_type IN VARCHAR2 := NULL,

Line 169: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

165: IF l_return_status = fnd_api.g_ret_sts_error
166: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
167: FOR l_counter IN 1 .. x_msg_count
168: LOOP
169: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
170: l_stmt_num := 2;
171: p_errnum := 1;
172: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
173: ' , ' || '): ' || l_counter ||

Line 323: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

319: IF l_return_status = fnd_api.g_ret_sts_error
320: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
321: FOR l_counter IN 1 .. x_msg_count
322: LOOP
323: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
324: l_stmt_num := 2;
325: p_errnum := 1;
326: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
327: ' , ' || '): ' || l_counter ||

Line 553: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

549: IF l_return_status = fnd_api.g_ret_sts_error
550: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
551: FOR l_counter IN 1 .. x_msg_count
552: LOOP
553: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
554: l_stmt_num := 2;
555: p_errnum := 1;
556: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
557: ' , ' || '): ' || l_counter ||

Line 744: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

740: OR l_return_status = fnd_api.g_ret_sts_unexp_error
741: THEN
742: FOR l_counter IN 1 .. x_msg_count
743: LOOP
744: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
745: l_stmt_num := 2;
746: p_errnum := 1;
747: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
748: ' , ' || '): ' || l_counter ||

Line 935: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

931: IF l_return_status = fnd_api.g_ret_sts_error
932: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
933: FOR l_counter IN 1 .. x_msg_count
934: LOOP
935: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
936: l_stmt_num := 2;
937: p_errnum := 1;
938: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
939: ' , ' || '): ' || l_counter ||

Line 1148: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

1144: IF l_return_status = fnd_api.g_ret_sts_error
1145: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1146: FOR l_counter IN 1 .. x_msg_count
1147: LOOP
1148: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
1149: l_stmt_num := 2;
1150: p_errnum := 1;
1151: p_errmsg := substr(l_mesg_text||' , '||
1152: TO_CHAR (l_stmt_num) ||

Line 1251: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

1247: IF l_return_status = fnd_api.g_ret_sts_error
1248: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1249: FOR l_counter IN 1 .. x_msg_count
1250: LOOP
1251: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
1252: l_stmt_num := 2;
1253: p_errnum := 1;
1254: p_errmsg := substr(l_mesg_text||' , '||
1255: TO_CHAR (l_stmt_num) ||

Line 1358: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

1354: IF l_return_status = fnd_api.g_ret_sts_error
1355: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1356: FOR l_counter IN 1 .. x_msg_count
1357: LOOP
1358: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
1359: l_stmt_num := 2;
1360: p_errnum := 1;
1361: p_errmsg := substr(l_mesg_text||' , '||
1362: TO_CHAR (l_stmt_num) ||

Line 1553: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

1549: IF l_return_status = fnd_api.g_ret_sts_error
1550: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1551: FOR l_counter IN 1 .. x_msg_count
1552: LOOP
1553: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
1554: l_stmt_num := 2;
1555: p_errnum := 1;
1556: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
1557: ' , ' || '): ' || l_counter ||

Line 1722: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

1718: IF l_return_status = fnd_api.g_ret_sts_error
1719: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1720: FOR l_counter IN 1 .. x_msg_count
1721: LOOP
1722: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
1723: l_stmt_num := 2;
1724: p_errnum := 1;
1725: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
1726: ' , ' || '): ' || l_counter ||

Line 1900: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

1896: IF l_return_status = fnd_api.g_ret_sts_error
1897: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1898: FOR l_counter IN 1 .. x_msg_count
1899: LOOP
1900: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
1901: l_stmt_num := 2;
1902: p_errnum := 1;
1903: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
1904: ' , ' || '): ' || l_counter ||

Line 2061: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

2057: IF l_return_status = fnd_api.g_ret_sts_error
2058: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2059: FOR l_counter IN 1 .. x_msg_count
2060: LOOP
2061: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2062: l_stmt_num := 2;
2063: p_errnum := 1;
2064: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
2065: ' , ' || '): ' || l_counter ||

Line 2210: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

2206: IF l_return_status = fnd_api.g_ret_sts_error
2207: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2208: FOR l_counter IN 1 .. x_msg_count
2209: LOOP
2210: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2211: l_stmt_num := 2;
2212: p_errnum := 1;
2213: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
2214: ' , ' || '): ' || l_counter ||

Line 2317: fnd_msg_pub.initialize;

2313: ams_utility_pvt.debug_message (l_full_name || ': start');
2314: END IF;
2315:
2316: IF fnd_api.to_boolean (p_init_msg_list) THEN
2317: fnd_msg_pub.initialize;
2318: END IF;
2319:
2320: IF NOT fnd_api.compatible_api_call (
2321: l_api_version,

Line 2351: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

2347:
2348: -- General Message saying copying has started
2349: fnd_message.set_name ('AMS', 'COPY_ACT_ELEMENTS');
2350: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
2351: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2352:
2353: -- Writing to the Pl/SQLtable
2354: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2355: p_src_camp_schedule_id,

Line 2422: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

2418: IF l_return_status = fnd_api.g_ret_sts_unexp_error OR
2419: l_return_status = fnd_api.g_ret_sts_error THEN
2420: FOR l_counter IN 1 .. x_msg_count
2421: LOOP
2422: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2423: p_errmsg := substr(l_mesg_text || '): ' || l_counter ||
2424: ' OF ' || x_msg_count, 1, 3000);
2425: ams_cpyutility_pvt.write_log_mesg ( 'CSCH',
2426: p_src_camp_schedule_id,

Line 2459: fnd_msg_pub.count_and_get (

2455: WHEN fnd_api.g_exc_error
2456: THEN
2457: ROLLBACK TO copy_campaign_schedules;
2458: x_return_status := fnd_api.g_ret_sts_error;
2459: fnd_msg_pub.count_and_get (
2460: p_encoded => fnd_api.g_false,
2461: p_count => x_msg_count,
2462: p_data => x_msg_data
2463: );

Line 2468: fnd_msg_pub.count_and_get (

2464: WHEN fnd_api.g_exc_unexpected_error
2465: THEN
2466: ROLLBACK TO copy_campaign_schedules;
2467: x_return_status := fnd_api.g_ret_sts_unexp_error;
2468: fnd_msg_pub.count_and_get (
2469: p_encoded => fnd_api.g_false,
2470: p_count => x_msg_count,
2471: p_data => x_msg_data
2472: );

Line 2478: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2474: THEN
2475: ROLLBACK TO copy_campaign_schedules;
2476: x_return_status := fnd_api.g_ret_sts_unexp_error;
2477:
2478: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2479: THEN
2480: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2481: END IF;
2482:

Line 2480: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2476: x_return_status := fnd_api.g_ret_sts_unexp_error;
2477:
2478: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2479: THEN
2480: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2481: END IF;
2482:
2483: fnd_msg_pub.count_and_get (
2484: p_encoded => fnd_api.g_false,

Line 2483: fnd_msg_pub.count_and_get (

2479: THEN
2480: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2481: END IF;
2482:
2483: fnd_msg_pub.count_and_get (
2484: p_encoded => fnd_api.g_false,
2485: p_count => x_msg_count,
2486: p_data => x_msg_data
2487: );

Line 2539: fnd_msg_pub.initialize;

2535:
2536: END IF;
2537: IF fnd_api.to_boolean (p_init_msg_list)
2538: THEN
2539: fnd_msg_pub.initialize;
2540: END IF;
2541:
2542: IF NOT fnd_api.compatible_api_call ( l_api_version,
2543: p_api_version,

Line 2571: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

2567: END IF;
2568: -- General Message saying copying has started
2569: fnd_message.set_name ('AMS', 'COPY_ACT_ELEMENTS');
2570: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
2571: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2572:
2573: -- Writing to the Pl/SQLtable
2574: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2575: p_old_camp_id,

Line 2613: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

2609: IF l_return_status = fnd_api.g_ret_sts_unexp_error OR
2610: l_return_status = fnd_api.g_ret_sts_error THEN
2611: FOR l_counter IN 1 .. x_msg_count
2612: LOOP
2613: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2614: p_errmsg := substr(l_mesg_text || '): ' || l_counter ||
2615: ' OF ' || x_msg_count, 1, 3000);
2616: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2617: p_old_camp_id,

Line 2660: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

2656: IF l_return_status = fnd_api.g_ret_sts_error OR
2657: l_return_status = fnd_api.g_ret_sts_unexp_error then
2658: FOR l_counter IN 1 .. x_msg_count
2659: LOOP
2660: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2661: p_errmsg := SUBSTR ( l_mesg_text || '): ' || l_counter ||
2662: ' OF ' || x_msg_count, 1, 3000);
2663: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2664: p_old_camp_id,

Line 2696: fnd_msg_pub.count_and_get (

2692: WHEN fnd_api.g_exc_error
2693: THEN
2694: ROLLBACK TO copy_tasks;
2695: x_return_status := fnd_api.g_ret_sts_error;
2696: fnd_msg_pub.count_and_get (
2697: p_encoded => fnd_api.g_false,
2698: p_count => x_msg_count,
2699: p_data => x_msg_data
2700: );

Line 2705: fnd_msg_pub.count_and_get (

2701: WHEN fnd_api.g_exc_unexpected_error
2702: THEN
2703: ROLLBACK TO copy_tasks;
2704: x_return_status := fnd_api.g_ret_sts_unexp_error;
2705: fnd_msg_pub.count_and_get (
2706: p_encoded => fnd_api.g_false,
2707: p_count => x_msg_count,
2708: p_data => x_msg_data
2709: );

Line 2715: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2711: THEN
2712: ROLLBACK TO copy_tasks;
2713: x_return_status := fnd_api.g_ret_sts_unexp_error;
2714:
2715: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2716: THEN
2717: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2718: END IF;
2719:

Line 2717: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2713: x_return_status := fnd_api.g_ret_sts_unexp_error;
2714:
2715: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2716: THEN
2717: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2718: END IF;
2719:
2720: fnd_msg_pub.count_and_get (
2721: p_encoded => fnd_api.g_false,

Line 2720: fnd_msg_pub.count_and_get (

2716: THEN
2717: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2718: END IF;
2719:
2720: fnd_msg_pub.count_and_get (
2721: p_encoded => fnd_api.g_false,
2722: p_count => x_msg_count,
2723: p_data => x_msg_data
2724: );

Line 2770: fnd_msg_pub.initialize;

2766: END IF;
2767:
2768: IF fnd_api.to_boolean (p_init_msg_list)
2769: THEN
2770: fnd_msg_pub.initialize;
2771: END IF;
2772:
2773: IF NOT fnd_api.compatible_api_call (
2774: l_api_version,

Line 2798: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

2794: );
2795: -- General Message saying copying has started
2796: fnd_message.set_name ('AMS', 'COPY_ACT_ELEMENTS');
2797: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
2798: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2799:
2800: -- Writing to the Pl/SQLtable
2801: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2802: p_old_camp_id,

Line 2859: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

2855: IF x_msg_count >= 1
2856: THEN
2857: FOR l_counter IN 1 .. x_msg_count
2858: LOOP
2859: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2860: p_errmsg := SUBSTR (
2861: l_mesg_text ||
2862: '): ' ||
2863: l_counter ||

Line 2918: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

2914: IF l_return_status = fnd_api.g_ret_sts_error
2915: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2916: FOR l_counter IN 1 .. x_msg_count
2917: LOOP
2918: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2919: p_errmsg := SUBSTR ( l_mesg_text || ' , ' || '): ' ||
2920: x_msg_count || ' OF ' || x_msg_count,
2921: 1, 4000);
2922: ams_cpyutility_pvt.write_log_mesg (

Line 2949: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,

2945: WHEN fnd_api.g_exc_error
2946: THEN
2947: ROLLBACK TO copy_partners;
2948: x_return_status := fnd_api.g_ret_sts_error;
2949: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,
2950: p_count => x_msg_count,
2951: p_data => x_msg_data
2952: );
2953: WHEN fnd_api.g_exc_unexpected_error

Line 2957: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,

2953: WHEN fnd_api.g_exc_unexpected_error
2954: THEN
2955: ROLLBACK TO copy_partners;
2956: x_return_status := fnd_api.g_ret_sts_unexp_error;
2957: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,
2958: p_count => x_msg_count,
2959: p_data => x_msg_data
2960: );
2961: WHEN OTHERS

Line 2966: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2962: THEN
2963: ROLLBACK TO copy_partners;
2964: x_return_status := fnd_api.g_ret_sts_unexp_error;
2965:
2966: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2967: THEN
2968: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2969: END IF;
2970:

Line 2968: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2964: x_return_status := fnd_api.g_ret_sts_unexp_error;
2965:
2966: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2967: THEN
2968: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2969: END IF;
2970:
2971: fnd_msg_pub.count_and_get (
2972: p_encoded => fnd_api.g_false,

Line 2971: fnd_msg_pub.count_and_get (

2967: THEN
2968: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2969: END IF;
2970:
2971: fnd_msg_pub.count_and_get (
2972: p_encoded => fnd_api.g_false,
2973: p_count => x_msg_count,
2974: p_data => x_msg_data
2975: );

Line 2982: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2978: EXCEPTION
2979: WHEN others THEN
2980: ROLLBACK TO copy_partners;
2981: x_return_status := fnd_api.g_ret_sts_unexp_error;
2982: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2983: THEN
2984: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2985: END IF;
2986: fnd_msg_pub.count_and_get (

Line 2984: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2980: ROLLBACK TO copy_partners;
2981: x_return_status := fnd_api.g_ret_sts_unexp_error;
2982: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2983: THEN
2984: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2985: END IF;
2986: fnd_msg_pub.count_and_get (
2987: p_encoded => fnd_api.g_false,
2988: p_count => x_msg_count,

Line 2986: fnd_msg_pub.count_and_get (

2982: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2983: THEN
2984: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2985: END IF;
2986: fnd_msg_pub.count_and_get (
2987: p_encoded => fnd_api.g_false,
2988: p_count => x_msg_count,
2989: p_data => x_msg_data
2990: );

Line 3042: FND_MSG_PUB.initialize;

3038: END IF;
3039:
3040: -- Initialize message list if p_init_msg_list is set to TRUE.
3041: IF FND_API.to_Boolean( p_init_msg_list )THEN
3042: FND_MSG_PUB.initialize;
3043: END IF;
3044:
3045: IF (AMS_DEBUG_HIGH_ON) THEN
3046:

Line 3104: FND_MSG_PUB.Count_And_Get (

3100: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
3101: END IF;
3102:
3103: -- Standard call to get message count and if count is 1, get message info.
3104: FND_MSG_PUB.Count_And_Get (
3105: p_count => x_msg_count,
3106: p_data => x_msg_data
3107: );
3108: EXCEPTION

Line 3113: FND_MSG_PUB.Count_And_Get (

3109: WHEN FND_API.G_EXC_ERROR THEN
3110: ROLLBACK TO copy_list_select_actions_pvt;
3111: x_return_status := FND_API.G_RET_STS_ERROR;
3112: -- Standard call to get message count and if count=1, get the message
3113: FND_MSG_PUB.Count_And_Get (
3114: p_encoded => FND_API.G_FALSE,
3115: p_count => x_msg_count,
3116: p_data => x_msg_data
3117: );

Line 3122: FND_MSG_PUB.Count_And_Get (

3118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3119: ROLLBACK TO copy_list_select_actions_pvt;
3120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3121: -- Standard call to get message count and if count=1, get the message
3122: FND_MSG_PUB.Count_And_Get (
3123: p_encoded => FND_API.G_FALSE,
3124: p_count => x_msg_count,
3125: p_data => x_msg_data
3126: );

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

3126: );
3127: WHEN OTHERS THEN
3128: ROLLBACK TO copy_list_select_actions_pvt;
3129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3130: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3131: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3132: END IF;
3133: -- Standard call to get message count and if count=1, get the message
3134: FND_MSG_PUB.Count_And_Get (

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

3127: WHEN OTHERS THEN
3128: ROLLBACK TO copy_list_select_actions_pvt;
3129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3130: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3131: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3132: END IF;
3133: -- Standard call to get message count and if count=1, get the message
3134: FND_MSG_PUB.Count_And_Get (
3135: p_encoded => FND_API.G_FALSE,

Line 3134: FND_MSG_PUB.Count_And_Get (

3130: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3131: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3132: END IF;
3133: -- Standard call to get message count and if count=1, get the message
3134: FND_MSG_PUB.Count_And_Get (
3135: p_encoded => FND_API.G_FALSE,
3136: p_count => x_msg_count,
3137: p_data => x_msg_data
3138: );

Line 3186: fnd_msg_pub.initialize;

3182: END IF;
3183:
3184: IF fnd_api.to_boolean (p_init_msg_list)
3185: THEN
3186: fnd_msg_pub.initialize;
3187: END IF;
3188:
3189: IF NOT fnd_api.compatible_api_call (
3190: l_api_version,

Line 3214: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

3210: );
3211: -- General Message saying copying has started
3212: fnd_message.set_name ('AMS', 'COPY_ACT_ELEMENTS');
3213: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
3214: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
3215:
3216: -- Writing to the Pl/SQLtable
3217: ams_cpyutility_pvt.write_log_mesg ( p_type,
3218: p_old_id,

Line 3267: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

3263: IF x_msg_count >= 1
3264: THEN
3265: FOR l_counter IN 1 .. x_msg_count
3266: LOOP
3267: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
3268: p_errmsg := SUBSTR (
3269: l_mesg_text ||
3270: '): ' ||
3271: l_counter ||

Line 3326: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

3322: IF l_return_status = fnd_api.g_ret_sts_error
3323: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3324: FOR l_counter IN 1 .. x_msg_count
3325: LOOP
3326: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
3327: p_errmsg := SUBSTR ( l_mesg_text || ' , ' || '): ' ||
3328: x_msg_count || ' OF ' || x_msg_count,
3329: 1, 4000);
3330: ams_cpyutility_pvt.write_log_mesg (

Line 3357: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,

3353: WHEN fnd_api.g_exc_error
3354: THEN
3355: ROLLBACK TO copy_partners;
3356: x_return_status := fnd_api.g_ret_sts_error;
3357: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,
3358: p_count => x_msg_count,
3359: p_data => x_msg_data
3360: );
3361: WHEN fnd_api.g_exc_unexpected_error

Line 3365: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,

3361: WHEN fnd_api.g_exc_unexpected_error
3362: THEN
3363: ROLLBACK TO copy_partners;
3364: x_return_status := fnd_api.g_ret_sts_unexp_error;
3365: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,
3366: p_count => x_msg_count,
3367: p_data => x_msg_data
3368: );
3369: WHEN OTHERS

Line 3374: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3370: THEN
3371: ROLLBACK TO copy_partners;
3372: x_return_status := fnd_api.g_ret_sts_unexp_error;
3373:
3374: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3375: THEN
3376: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3377: END IF;
3378:

Line 3376: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3372: x_return_status := fnd_api.g_ret_sts_unexp_error;
3373:
3374: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3375: THEN
3376: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3377: END IF;
3378:
3379: fnd_msg_pub.count_and_get (
3380: p_encoded => fnd_api.g_false,

Line 3379: fnd_msg_pub.count_and_get (

3375: THEN
3376: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3377: END IF;
3378:
3379: fnd_msg_pub.count_and_get (
3380: p_encoded => fnd_api.g_false,
3381: p_count => x_msg_count,
3382: p_data => x_msg_data
3383: );

Line 3390: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3386: EXCEPTION
3387: WHEN others THEN
3388: ROLLBACK TO copy_partners;
3389: x_return_status := fnd_api.g_ret_sts_unexp_error;
3390: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3391: THEN
3392: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3393: END IF;
3394: fnd_msg_pub.count_and_get (

Line 3392: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3388: ROLLBACK TO copy_partners;
3389: x_return_status := fnd_api.g_ret_sts_unexp_error;
3390: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3391: THEN
3392: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3393: END IF;
3394: fnd_msg_pub.count_and_get (
3395: p_encoded => fnd_api.g_false,
3396: p_count => x_msg_count,

Line 3394: fnd_msg_pub.count_and_get (

3390: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3391: THEN
3392: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3393: END IF;
3394: fnd_msg_pub.count_and_get (
3395: p_encoded => fnd_api.g_false,
3396: p_count => x_msg_count,
3397: p_data => x_msg_data
3398: );

Line 3577: FND_MSG_PUB.Count_And_Get

3573: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3574: END IF;
3575:
3576: -- Standard call to get message count and if count is 1, get message info.
3577: FND_MSG_PUB.Count_And_Get
3578: (p_count => x_msg_count,
3579: p_data => x_msg_data
3580: );
3581: EXCEPTION

Line 3597: FND_MSG_PUB.Count_And_Get (

3593: CLOSE c_schedule_det ;
3594: END IF ;
3595: x_return_status := FND_API.G_RET_STS_ERROR;
3596: -- Standard call to get message count and if count=1, get the message
3597: FND_MSG_PUB.Count_And_Get (
3598: p_encoded => FND_API.G_FALSE,
3599: p_count => x_msg_count,
3600: p_data => x_msg_data
3601: );

Line 3610: FND_MSG_PUB.Count_And_Get (

3606: CLOSE c_schedule_det ;
3607: END IF ;
3608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3609: -- Standard call to get message count and if count=1, get the message
3610: FND_MSG_PUB.Count_And_Get (
3611: p_encoded => FND_API.G_FALSE,
3612: p_count => x_msg_count,
3613: p_data => x_msg_data
3614: );

Line 3622: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3618: IF c_schedule_det%ISOPEN THEN
3619: CLOSE c_schedule_det ;
3620: END IF ;
3621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3622: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3623: THEN
3624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3625: END IF;
3626: -- Standard call to get message count and if count=1, get the message

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

3620: END IF ;
3621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3622: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3623: THEN
3624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3625: END IF;
3626: -- Standard call to get message count and if count=1, get the message
3627: FND_MSG_PUB.Count_And_Get (
3628: p_encoded => FND_API.G_FALSE,

Line 3627: FND_MSG_PUB.Count_And_Get (

3623: THEN
3624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3625: END IF;
3626: -- Standard call to get message count and if count=1, get the message
3627: FND_MSG_PUB.Count_And_Get (
3628: p_encoded => FND_API.G_FALSE,
3629: p_count => x_msg_count,
3630: p_data => x_msg_data
3631: );

Line 4065: FND_MSG_PUB.Count_And_Get

4061: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
4062: END IF;
4063:
4064: -- Standard call to get message count and if count is 1, get message info.
4065: FND_MSG_PUB.Count_And_Get
4066: (p_count => x_msg_count,
4067: p_data => x_msg_data
4068: );
4069: EXCEPTION

Line 4085: FND_MSG_PUB.Count_And_Get (

4081: CLOSE c_schedule_details ;
4082: END IF ;
4083: x_return_status := FND_API.G_RET_STS_ERROR;
4084: -- Standard call to get message count and if count=1, get the message
4085: FND_MSG_PUB.Count_And_Get (
4086: p_encoded => FND_API.G_FALSE,
4087: p_count => x_msg_count,
4088: p_data => x_msg_data
4089: );

Line 4098: FND_MSG_PUB.Count_And_Get (

4094: CLOSE c_schedule_details ;
4095: END IF ;
4096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4097: -- Standard call to get message count and if count=1, get the message
4098: FND_MSG_PUB.Count_And_Get (
4099: p_encoded => FND_API.G_FALSE,
4100: p_count => x_msg_count,
4101: p_data => x_msg_data
4102: );

Line 4110: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4106: IF c_schedule_details%ISOPEN THEN
4107: CLOSE c_schedule_details ;
4108: END IF ;
4109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4110: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4111: THEN
4112: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4113: END IF;
4114: -- Standard call to get message count and if count=1, get the message

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

4108: END IF ;
4109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4110: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4111: THEN
4112: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4113: END IF;
4114: -- Standard call to get message count and if count=1, get the message
4115: FND_MSG_PUB.Count_And_Get (
4116: p_encoded => FND_API.G_FALSE,

Line 4115: FND_MSG_PUB.Count_And_Get (

4111: THEN
4112: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4113: END IF;
4114: -- Standard call to get message count and if count=1, get the message
4115: FND_MSG_PUB.Count_And_Get (
4116: p_encoded => FND_API.G_FALSE,
4117: p_count => x_msg_count,
4118: p_data => x_msg_data
4119: );

Line 4256: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

4252: IF l_return_status = fnd_api.g_ret_sts_error
4253: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4254: FOR l_counter IN 1 .. x_msg_count
4255: LOOP
4256: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
4257: l_stmt_num := 2;
4258: p_errnum := 1;
4259: p_errmsg := substr(l_mesg_text||' , '||
4260: TO_CHAR (l_stmt_num) ||

Line 4372: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

4368: OR l_return_status = fnd_api.g_ret_sts_unexp_error
4369: THEN
4370: FOR l_counter IN 1 .. l_msg_count
4371: LOOP
4372: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
4373: l_stmt_num := 1;
4374: p_errnum := 1;
4375: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
4376: ' , ' || '): ' || l_counter ||

Line 4437: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

4433: OR l_return_status = fnd_api.g_ret_sts_unexp_error
4434: THEN
4435: FOR l_counter IN 1 .. l_msg_count
4436: LOOP
4437: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
4438: l_stmt_num := 1;
4439: p_errnum := 1;
4440: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
4441: ' , ' || '): ' || l_counter ||

Line 4581: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

4577: IF l_return_status = fnd_api.g_ret_sts_error
4578: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4579: FOR l_counter IN 1 .. x_msg_count
4580: LOOP
4581: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
4582: l_stmt_num := 2;
4583: p_errnum := 1;
4584: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
4585: ' , ' || '): ' || l_counter ||