[Home] [Help]
968: S: Synchronization mode. This mode is passed when the API is called from the Synchronization process for the template rebuild concurrent program
969:
970: U: UI mode: This mode is passed from the 'Question Reorder UI'.
971:
972: x_Return_Status, x_Msg_Count, x_Msg_Data : Standard parameters for exception handling.
973: */
974: BEGIN
975:
976: -- start debug log
1854:
1855: x_return_status := G_RET_STS_SUCCESS;
1856:
1857: IF (p_calling_mode = 'PUBLISH' OR p_calling_mode = 'DISABLE' OR p_calling_mode = 'SYNC') THEN
1858: -- Standard Start of API savepoint
1859: SAVEPOINT g_create_prod_publication;
1860: END IF;
1861:
1862: --START: Perf Bug 5032199 Using REF cursor
2293: END IF;
2294:
2295:
2296: --
2297: -- Standard call to check for call compatibility.
2298: --
2299: IF NOT FND_API.Compatible_API_Call (l_api_version,
2300: p_api_version,
2301: l_api_name,
2625:
2626: x_return_status := G_RET_STS_SUCCESS;
2627:
2628: --
2629: -- Standard call to check for call compatibility.
2630: --
2631: IF NOT FND_API.Compatible_API_Call (l_api_version,
2632: p_api_version,
2633: l_api_name,
3893:
3894: END IF;
3895:
3896: --
3897: -- Standard call to check for call compatibility.
3898: --
3899: IF NOT FND_API.Compatible_API_Call (l_api_version,
3900: p_api_version,
3901: l_api_name,
4134: BEGIN
4135:
4136:
4137: --
4138: -- Standard call to check for call compatibility.
4139: --
4140: IF NOT FND_API.Compatible_API_Call (l_api_version,
4141: p_api_version,
4142: l_api_name,
4433:
4434: BEGIN
4435:
4436: --
4437: -- Standard call to check for call compatibility.
4438: --
4439: IF NOT FND_API.Compatible_API_Call (l_api_version,
4440: p_api_version,
4441: l_api_name,
4663: BEGIN
4664:
4665: l_doc_lib := 'D';
4666:
4667: -- Standard call to check for call compatibility.
4668: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4670: END IF;
4671: -- Initialize message list if p_init_msg_list is set to TRUE.
6565: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
6566: END IF;
6567:
6568: --
6569: -- Standard call to check for call compatibility.
6570: --
6571: IF NOT FND_API.Compatible_API_Call (l_api_version,
6572: p_api_version,
6573: l_api_name,
6613: x_msg_data => x_msg_data
6614: ) ;
6615:
6616:
6617: -- Standard call to get message count and if count is 1, get message info.
6618: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6619:
6620:
6621: -- end debug log
6839: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
6840: END IF;
6841:
6842: --
6843: -- Standard call to check for call compatibility.
6844: --
6845: IF NOT FND_API.Compatible_API_Call (l_api_version,
6846: p_api_version,
6847: l_api_name,
7156:
7157: END IF;
7158:
7159: --
7160: -- Standard call to check for call compatibility.
7161: --
7162: IF NOT FND_API.Compatible_API_Call (l_api_version,
7163: p_api_version,
7164: l_api_name,
7368: END IF;
7369: END IF;
7370:
7371: --
7372: -- Standard call to check for call compatibility.
7373: --
7374: IF NOT FND_API.Compatible_API_Call (l_api_version,
7375: p_api_version,
7376: l_api_name,
7522: END IF;
7523: END IF;
7524:
7525: --
7526: -- Standard call to check for call compatibility.
7527: --
7528: IF NOT FND_API.Compatible_API_Call (l_api_version,
7529: p_api_version,
7530: l_api_name,
7703:
7704: END IF;
7705:
7706: --
7707: -- Standard call to check for call compatibility.
7708: --
7709: IF NOT FND_API.Compatible_API_Call (l_api_version,
7710: p_api_version,
7711: l_api_name,
7911: '101: p_effectivity_date : '||to_char(p_effectivity_date));
7912: END IF;
7913:
7914: --
7915: -- Standard call to check for call compatibility.
7916: --
7917: IF NOT FND_API.Compatible_API_Call (l_api_version,
7918: p_api_version,
7919: l_api_name,
8264: END IF;
8265: END IF;
8266:
8267: --
8268: -- Standard call to check for call compatibility.
8269: --
8270: IF NOT FND_API.Compatible_API_Call (l_api_version,
8271: p_api_version,
8272: l_api_name,
8636:
8637: END IF;
8638:
8639: --
8640: -- Standard call to check for call compatibility.
8641: --
8642: IF NOT FND_API.Compatible_API_Call (l_api_version,
8643: p_api_version,
8644: l_api_name,
9168: x_return_status := FND_API.G_RET_STS_SUCCESS;
9169:
9170:
9171: --
9172: -- Standard call to check for call compatibility.
9173: --
9174: IF NOT FND_API.Compatible_API_Call (l_api_version,
9175: p_api_version,
9176: l_api_name,
10231: END IF; --IF(p_bv_mode <> 'DEV')
10232: END IF;
10233:
10234: --
10235: -- Standard call to get message count and if count is 1, get message info.
10236: --
10237: FND_MSG_PUB.Count_And_Get(
10238: p_count => x_msg_count,
10239: p_data => x_msg_data
10328: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
10329: END IF;
10330:
10331: --
10332: -- Standard call to check for call compatibility.
10333: --
10334: IF NOT FND_API.Compatible_API_Call (l_api_version,
10335: p_api_version,
10336: l_api_name,
10475: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
10476: END IF;
10477:
10478: --
10479: -- Standard call to check for call compatibility.
10480: --
10481: IF NOT FND_API.Compatible_API_Call (l_api_version,
10482: p_api_version,
10483: l_api_name,
10899: BEGIN
10900:
10901:
10902: --
10903: -- Standard call to check for call compatibility.
10904: --
10905: IF NOT FND_API.Compatible_API_Call (l_api_version,
10906: p_api_version,
10907: l_api_name,