DBA Data[Home] [Help]

APPS.PV_REFERRAL_GENERAL_PUB dependencies on FND_MSG_PUB

Line 21: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

17: g_module_name VARCHAR2(48);
18:
19:
20: PV_DEBUG_HIGH_ON boolean :=
21: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: PV_DEBUG_LOW_ON boolean :=
23: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
24: PV_DEBUG_MEDIUM_ON boolean :=
25: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

Line 23: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

19:
20: PV_DEBUG_HIGH_ON boolean :=
21: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: PV_DEBUG_LOW_ON boolean :=
23: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
24: PV_DEBUG_MEDIUM_ON boolean :=
25: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26: PV_DEBUG_ERROR_ON boolean :=
27: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);

Line 25: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

21: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: PV_DEBUG_LOW_ON boolean :=
23: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
24: PV_DEBUG_MEDIUM_ON boolean :=
25: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26: PV_DEBUG_ERROR_ON boolean :=
27: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
28:
29:

Line 27: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);

23: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
24: PV_DEBUG_MEDIUM_ON boolean :=
25: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26: PV_DEBUG_ERROR_ON boolean :=
27: FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
28:
29:
30:
31: /*************************************************************************************/

Line 363: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

359: EXCEPTION
360: WHEN FND_API.G_EXC_ERROR THEN
361: g_RETCODE := '1';
362:
363: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
364: p_count => l_msg_count,
365: p_data => l_msg_data);
366:
367: WHEN FND_API.g_exc_unexpected_error THEN

Line 370: FND_MSG_PUB.count_and_get(

366:
367: WHEN FND_API.g_exc_unexpected_error THEN
368: g_RETCODE := '1';
369:
370: FND_MSG_PUB.count_and_get(
371: p_encoded => FND_API.g_false,
372: p_count => l_msg_count,
373: p_data => l_msg_data
374: );

Line 379: FND_MSG_PUB.count_and_get(

375:
376: WHEN OTHERS THEN
377: g_RETCODE := '1';
378:
379: FND_MSG_PUB.count_and_get(
380: p_encoded => FND_API.g_false,
381: p_count => l_msg_count,
382: p_data => l_msg_data
383: );

Line 468: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

464: EXCEPTION
465: WHEN FND_API.G_EXC_ERROR THEN
466: g_RETCODE := '1';
467:
468: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
469: p_count => l_msg_count,
470: p_data => l_msg_data);
471:
472: WHEN FND_API.g_exc_unexpected_error THEN

Line 475: FND_MSG_PUB.count_and_get(

471:
472: WHEN FND_API.g_exc_unexpected_error THEN
473: g_RETCODE := '1';
474:
475: FND_MSG_PUB.count_and_get(
476: p_encoded => FND_API.g_false,
477: p_count => l_msg_count,
478: p_data => l_msg_data
479: );

Line 484: FND_MSG_PUB.count_and_get(

480:
481: WHEN OTHERS THEN
482: g_RETCODE := '1';
483:
484: FND_MSG_PUB.count_and_get(
485: p_encoded => FND_API.g_false,
486: p_count => l_msg_count,
487: p_data => l_msg_data
488: );

Line 571: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN
569: g_RETCODE := '1';
570:
571: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
572: p_count => l_msg_count,
573: p_data => l_msg_data);
574:
575: WHEN FND_API.g_exc_unexpected_error THEN

Line 578: FND_MSG_PUB.count_and_get(

574:
575: WHEN FND_API.g_exc_unexpected_error THEN
576: g_RETCODE := '1';
577:
578: FND_MSG_PUB.count_and_get(
579: p_encoded => FND_API.g_false,
580: p_count => l_msg_count,
581: p_data => l_msg_data
582: );

Line 587: FND_MSG_PUB.count_and_get(

583:
584: WHEN OTHERS THEN
585: g_RETCODE := '1';
586:
587: FND_MSG_PUB.count_and_get(
588: p_encoded => FND_API.g_false,
589: p_count => l_msg_count,
590: p_data => l_msg_data
591: );

Line 677: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

673: EXCEPTION
674: WHEN FND_API.G_EXC_ERROR THEN
675: g_RETCODE := '1';
676:
677: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
678: p_count => l_msg_count,
679: p_data => l_msg_data);
680:
681: WHEN FND_API.g_exc_unexpected_error THEN

Line 684: FND_MSG_PUB.count_and_get(

680:
681: WHEN FND_API.g_exc_unexpected_error THEN
682: g_RETCODE := '1';
683:
684: FND_MSG_PUB.count_and_get(
685: p_encoded => FND_API.g_false,
686: p_count => l_msg_count,
687: p_data => l_msg_data
688: );

Line 693: FND_MSG_PUB.count_and_get(

689:
690: WHEN OTHERS THEN
691: g_RETCODE := '1';
692:
693: FND_MSG_PUB.count_and_get(
694: p_encoded => FND_API.g_false,
695: p_count => l_msg_count,
696: p_data => l_msg_data
697: );

Line 757: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

753: EXCEPTION
754: WHEN FND_API.G_EXC_ERROR THEN
755: g_RETCODE := '1';
756:
757: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
758: p_count => l_msg_count,
759: p_data => l_msg_data);
760:
761: WHEN FND_API.g_exc_unexpected_error THEN

Line 764: FND_MSG_PUB.count_and_get(

760:
761: WHEN FND_API.g_exc_unexpected_error THEN
762: g_RETCODE := '1';
763:
764: FND_MSG_PUB.count_and_get(
765: p_encoded => FND_API.g_false,
766: p_count => l_msg_count,
767: p_data => l_msg_data
768: );

Line 773: FND_MSG_PUB.count_and_get(

769:
770: WHEN OTHERS THEN
771: g_RETCODE := '1';
772:
773: FND_MSG_PUB.count_and_get(
774: p_encoded => FND_API.g_false,
775: p_count => l_msg_count,
776: p_data => l_msg_data
777: );

Line 1015: FND_MSG_PUB.initialize;

1011:
1012:
1013: -------------------- initialize -------------------------
1014: IF FND_API.to_boolean(p_init_msg_list) THEN
1015: FND_MSG_PUB.initialize;
1016: END IF;
1017:
1018: IF NOT FND_API.compatible_api_call(
1019: l_api_version,

Line 1106: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1102: -- -------------------------------------------------------------------
1103: l_invoker_salesgroup_id := Get_Salesgroup_ID(l_invoker_resource_id);
1104:
1105: IF (l_invoker_salesgroup_id IS NULL) THEN
1106: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1107: p_msg_name => 'PV_RESOURCE_NO_SALES_GROUP',
1108: p_token1 => 'Invoker Resource ID',
1109: p_token1_value => l_invoker_resource_id);
1110:

Line 1200: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1196: IF (l_benefit_type = 'PVREFFRL') THEN
1197: IF (l_sales_transaction_type = 'LEAD_PARTNER') THEN
1198:
1199: IF (l_PV_INDIRECT_CHANNEL_TYPE IS NULL) THEN
1200: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1201: p_msg_name => 'PV_NO_INDIRECT_CHANNEL_TYPE',
1202: p_token1 => null,
1203: p_token1_value => null);
1204: RAISE FND_API.G_EXC_ERROR;

Line 1216: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1212: -- The channel type for deal registration is always indirect.
1213: -- -------------------------------------------------------------------
1214: ELSE
1215: IF (l_PV_INDIRECT_CHANNEL_TYPE IS NULL) THEN
1216: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1217: p_msg_name => 'PV_NO_INDIRECT_CHANNEL_TYPE',
1218: p_token1 => null,
1219: p_token1_value => null);
1220: RAISE FND_API.G_EXC_ERROR;

Line 1371: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1367:
1368: -- -------------------------------------------------------------------
1369: -- Log the fact that the opportunity has been created.
1370: -- -------------------------------------------------------------------
1371: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1372: p_msg_name => 'PV_REFERRAL_OPPTY_CREATION',
1373: p_token1 => 'OPPTY_NAME',
1374: p_token1_value => l_referral_code,
1375: p_token2 => 'USER',

Line 1551: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1547:
1548: -- -------------------------------------------------------------------
1549: -- Log the fact that the lead has been created.
1550: -- -------------------------------------------------------------------
1551: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1552: p_msg_name => 'PV_REFERRAL_LEAD_CREATION',
1553: p_token1 => 'LEAD_NAME',
1554: p_token1_value => l_referral_code,
1555: p_token2 => 'USER',

Line 1621: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1617: -- Add the resource to the sales team only if the resource belongs to
1618: -- a sales group.
1619: -- -----------------------------------------------------------------------
1620: IF (l_sales_team_rec.sales_group_id IS NULL) THEN
1621: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1622: p_msg_name => 'PV_RESOURCE_NO_SALES_GROUP',
1623: p_token1 => 'Approver Resource ID',
1624: p_token1_value => x.approver_resource_id);
1625:

Line 1748: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1744:
1745: l_sales_team_rec.person_id := l_channel_manager_tbl(i).person_id;
1746:
1747: IF (l_sales_team_rec.sales_group_id IS NULL) THEN
1748: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1749: p_msg_name => 'PV_RESOURCE_NO_SALES_GROUP',
1750: p_token1 => 'Channel Manager Resource ID',
1751: p_token1_value => l_channel_manager_tbl(i).resource_id);
1752:

Line 1807: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1803: -- -------------------------------------------------------------------
1804: l_pt_salesgroup_id := Get_Salesgroup_ID(l_partner_contact_rs_id);
1805:
1806: IF (l_pt_salesgroup_id IS NULL) THEN
1807: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1808: p_msg_name => 'PV_RESOURCE_NO_SALES_GROUP',
1809: p_token1 => 'Partner Contact Resource ID',
1810: p_token1_value => l_partner_contact_rs_id);
1811:

Line 1935: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

1931: EXCEPTION
1932: WHEN FND_API.G_EXC_ERROR THEN
1933: ROLLBACK;
1934: x_return_status := FND_API.G_RET_STS_ERROR;
1935: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1936: p_count => x_msg_count,
1937: p_data => x_msg_data);
1938:
1939: WHEN FND_API.g_exc_unexpected_error THEN

Line 1942: FND_MSG_PUB.count_and_get(

1938:
1939: WHEN FND_API.g_exc_unexpected_error THEN
1940: ROLLBACK;
1941: x_return_status := FND_API.g_ret_sts_unexp_error;
1942: FND_MSG_PUB.count_and_get(
1943: p_encoded => FND_API.g_false,
1944: p_count => x_msg_count,
1945: p_data => x_msg_data
1946: );

Line 1950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1946: );
1947:
1948: WHEN OTHERS THEN
1949: ROLLBACK;
1950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1951: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_api_name);
1952: END IF;
1953:
1954: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1951: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_api_name);

1947:
1948: WHEN OTHERS THEN
1949: ROLLBACK;
1950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1951: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_api_name);
1952: END IF;
1953:
1954: x_return_status := FND_API.G_RET_STS_ERROR;
1955: FND_MSG_PUB.count_and_get(

Line 1955: FND_MSG_PUB.count_and_get(

1951: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_api_name);
1952: END IF;
1953:
1954: x_return_status := FND_API.G_RET_STS_ERROR;
1955: FND_MSG_PUB.count_and_get(
1956: p_encoded => FND_API.g_false,
1957: p_count => x_msg_count,
1958: p_data => x_msg_data
1959: );

Line 2032: FND_MSG_PUB.initialize;

2028: Debug('API called: ' || g_pkg_name || '.' || g_api_name);
2029:
2030: -------------------- initialize -------------------------
2031: IF FND_API.to_boolean(p_init_msg_list) THEN
2032: FND_MSG_PUB.initialize;
2033: END IF;
2034:
2035: IF NOT FND_API.compatible_api_call(
2036: l_api_version,

Line 2188: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

2184: EXCEPTION
2185: WHEN FND_API.G_EXC_ERROR THEN
2186: ROLLBACK;
2187: x_return_status := FND_API.G_RET_STS_ERROR;
2188: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2189: p_count => x_msg_count,
2190: p_data => x_msg_data);
2191:
2192: WHEN FND_API.g_exc_unexpected_error THEN

Line 2195: FND_MSG_PUB.count_and_get(

2191:
2192: WHEN FND_API.g_exc_unexpected_error THEN
2193: ROLLBACK;
2194: x_return_status := FND_API.g_ret_sts_unexp_error;
2195: FND_MSG_PUB.count_and_get(
2196: p_encoded => FND_API.g_false,
2197: p_count => x_msg_count,
2198: p_data => x_msg_data
2199: );

Line 2203: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2199: );
2200:
2201: WHEN OTHERS THEN
2202: ROLLBACK;
2203: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2204: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_api_name);
2205: END IF;
2206:
2207: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2204: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_api_name);

2200:
2201: WHEN OTHERS THEN
2202: ROLLBACK;
2203: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2204: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_api_name);
2205: END IF;
2206:
2207: x_return_status := FND_API.G_RET_STS_ERROR;
2208: FND_MSG_PUB.count_and_get(

Line 2208: FND_MSG_PUB.count_and_get(

2204: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_api_name);
2205: END IF;
2206:
2207: x_return_status := FND_API.G_RET_STS_ERROR;
2208: FND_MSG_PUB.count_and_get(
2209: p_encoded => FND_API.g_false,
2210: p_count => x_msg_count,
2211: p_data => x_msg_data
2212: );

Line 2378: FND_MSG_PUB.Add;

2374: FND_MESSAGE.Set_Name('PV', p_msg_type);
2375: FND_MESSAGE.Set_Token(p_token_type, p_msg_string);
2376:
2377: IF (g_log_to_file = 'N') THEN
2378: FND_MSG_PUB.Add;
2379:
2380: ELSIF (g_log_to_file = 'Y') THEN
2381: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
2382: END IF;

Line 2464: FND_MSG_PUB.Add;

2460: IF (p_token3 IS NOT NULL) THEN
2461: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
2462: END IF;
2463:
2464: FND_MSG_PUB.Add;
2465: END Set_Message;
2466: -- ==============================End of Set_Message==============================
2467:
2468: