261:
262: -- Initialize API return status to success
263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264:
265: FND_MESSAGE.Set_Name(p_application_code, p_message_nm);
266: IF (p_arg1 IS NOT NULL) THEN
267: FND_MESSAGE.Set_Token('ARG1', p_arg1);
268: END IF;
269: IF (p_arg2 IS NOT NULL) THEN
263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264:
265: FND_MESSAGE.Set_Name(p_application_code, p_message_nm);
266: IF (p_arg1 IS NOT NULL) THEN
267: FND_MESSAGE.Set_Token('ARG1', p_arg1);
268: END IF;
269: IF (p_arg2 IS NOT NULL) THEN
270: FND_MESSAGE.Set_Token('ARG2', p_arg2);
271: END IF;
266: IF (p_arg1 IS NOT NULL) THEN
267: FND_MESSAGE.Set_Token('ARG1', p_arg1);
268: END IF;
269: IF (p_arg2 IS NOT NULL) THEN
270: FND_MESSAGE.Set_Token('ARG2', p_arg2);
271: END IF;
272: x_message := FND_MESSAGE.Get;
273:
274: --Standard check of commit
268: END IF;
269: IF (p_arg2 IS NOT NULL) THEN
270: FND_MESSAGE.Set_Token('ARG2', p_arg2);
271: END IF;
272: x_message := FND_MESSAGE.Get;
273:
274: --Standard check of commit
275: IF FND_API.To_Boolean ( p_commit ) THEN
276: COMMIT WORK;
377: x_return_status := FND_API.G_RET_STS_SUCCESS;
378:
379:
380: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
381: FND_MESSAGE.Set_Name(p_application_code, p_message_nm);
382: IF (p_arg1 IS NOT NULL) THEN
383: FND_MESSAGE.Set_Token('ARG1', p_arg1);
384: END IF;
385: IF (p_arg2 IS NOT NULL) THEN
379:
380: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
381: FND_MESSAGE.Set_Name(p_application_code, p_message_nm);
382: IF (p_arg1 IS NOT NULL) THEN
383: FND_MESSAGE.Set_Token('ARG1', p_arg1);
384: END IF;
385: IF (p_arg2 IS NOT NULL) THEN
386: FND_MESSAGE.Set_Token('ARG2', p_arg2);
387: END IF;
382: IF (p_arg1 IS NOT NULL) THEN
383: FND_MESSAGE.Set_Token('ARG1', p_arg1);
384: END IF;
385: IF (p_arg2 IS NOT NULL) THEN
386: FND_MESSAGE.Set_Token('ARG2', p_arg2);
387: END IF;
388: FND_MSG_PUB.Add;
389: END IF;
390:
497: x_return_status := FND_API.G_RET_STS_SUCCESS;
498:
499:
500: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
501: FND_MESSAGE.Set_Name(p_application_code, p_message_nm);
502: IF (p_arg1 IS NOT NULL) THEN
503: FND_MESSAGE.Set_Token('ARG1', p_arg1);
504: END IF;
505: IF (p_arg2 IS NOT NULL) THEN
499:
500: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
501: FND_MESSAGE.Set_Name(p_application_code, p_message_nm);
502: IF (p_arg1 IS NOT NULL) THEN
503: FND_MESSAGE.Set_Token('ARG1', p_arg1);
504: END IF;
505: IF (p_arg2 IS NOT NULL) THEN
506: FND_MESSAGE.Set_Token('ARG2', p_arg2);
507: END IF;
502: IF (p_arg1 IS NOT NULL) THEN
503: FND_MESSAGE.Set_Token('ARG1', p_arg1);
504: END IF;
505: IF (p_arg2 IS NOT NULL) THEN
506: FND_MESSAGE.Set_Token('ARG2', p_arg2);
507: END IF;
508: FND_MSG_PUB.Add;
509: END IF;
510:
507: END IF;
508: FND_MSG_PUB.Add;
509: END IF;
510:
511: FND_MESSAGE.Set_Name(p_application_code, p_message_nm);
512: IF (p_arg1 IS NOT NULL) THEN
513: FND_MESSAGE.Set_Token('ARG1', p_arg1);
514: END IF;
515: IF (p_arg2 IS NOT NULL) THEN
509: END IF;
510:
511: FND_MESSAGE.Set_Name(p_application_code, p_message_nm);
512: IF (p_arg1 IS NOT NULL) THEN
513: FND_MESSAGE.Set_Token('ARG1', p_arg1);
514: END IF;
515: IF (p_arg2 IS NOT NULL) THEN
516: FND_MESSAGE.Set_Token('ARG2', p_arg2);
517: END IF;
512: IF (p_arg1 IS NOT NULL) THEN
513: FND_MESSAGE.Set_Token('ARG1', p_arg1);
514: END IF;
515: IF (p_arg2 IS NOT NULL) THEN
516: FND_MESSAGE.Set_Token('ARG2', p_arg2);
517: END IF;
518: x_message := FND_MESSAGE.Get;
519:
520: --Standard check of commit
514: END IF;
515: IF (p_arg2 IS NOT NULL) THEN
516: FND_MESSAGE.Set_Token('ARG2', p_arg2);
517: END IF;
518: x_message := FND_MESSAGE.Get;
519:
520: --Standard check of commit
521: IF FND_API.To_Boolean ( p_commit ) THEN
522: COMMIT WORK;
705:
706: BEGIN
707: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
708: THEN
709: FND_MESSAGE.set_name('JTF', p_name);
710: FND_MESSAGE.Set_Token('ARG1',p_token);
711: FND_MSG_PUB.Add;
712: END IF;
713: RAISE FND_API.G_EXC_ERROR;
706: BEGIN
707: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
708: THEN
709: FND_MESSAGE.set_name('JTF', p_name);
710: FND_MESSAGE.Set_Token('ARG1',p_token);
711: FND_MSG_PUB.Add;
712: END IF;
713: RAISE FND_API.G_EXC_ERROR;
714:
721:
722: BEGIN
723: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
724: THEN
725: FND_MESSAGE.set_name('JTF', p_name);
726: FND_MSG_PUB.Add;
727: END IF;
728: RAISE FND_API.G_EXC_ERROR;
729:
1293: -- Debug Message
1294:
1295: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1296: THEN
1297: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
1298: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
1299: FND_MSG_PUB.Add;
1300: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
1301:
1294:
1295: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1296: THEN
1297: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
1298: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
1299: FND_MSG_PUB.Add;
1300: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
1301:
1302: -- Initialize API return status to success
1308: THEN
1309: l_Error_Msg := 'Must pass p_user_id parameter';
1310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1311: THEN
1312: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_USER_ID');
1313: FND_MSG_PUB.Add;
1314: END IF; -- FND_MSG_PUB.check_msg_level
1315: RAISE FND_API.G_EXC_ERROR;
1316:
1319: THEN
1320: l_Error_Msg := 'Must pass a valid Content_XML parameter';
1321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1322: THEN
1323: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_XML');
1324: FND_MSG_PUB.Add;
1325: END IF; -- IF FND_MSG_PUB.check_msg_level
1326: RAISE FND_API.G_EXC_ERROR;
1327:
1329: THEN
1330: l_Error_Msg := 'Must pass p_request_id parameter';
1331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1332: THEN
1333: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
1334: FND_MSG_PUB.Add;
1335: END IF; -- IF FND_MSG_PUB.check_msg_level
1336: RAISE FND_API.G_EXC_ERROR;
1337: ELSE -- IF (p_user_id IS NULL)
1344: || 'exists in the JTF_FM_REQUEST_HISTORY table';
1345:
1346: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1347: THEN
1348: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_REQUESTID_REUSED');
1349: FND_MSG_PUB.Add;
1350: END IF; -- IF FND_MSG_PUB.check_msg_level
1351:
1352: RAISE FND_API.G_EXC_ERROR;
1803: END IF; -- IF (p_user_id IS NULL)
1804:
1805: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1806: THEN
1807: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
1808: FND_MESSAGE.Set_Token('ARG1', l_full_name);
1809: FND_MSG_PUB.Add;
1810: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
1811:
1804:
1805: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1806: THEN
1807: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');
1808: FND_MESSAGE.Set_Token('ARG1', l_full_name);
1809: FND_MSG_PUB.Add;
1810: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
1811:
1812: --Standard check of commit
1818:
1819: -- Debug Message
1820: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1821: THEN
1822: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
1823: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
1824: FND_MSG_PUB.Add;
1825: END IF; -- IF FND_MSG.PUB.Check_Msg_level
1826:
1819: -- Debug Message
1820: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1821: THEN
1822: FND_MESSAGE.Set_Name('JTF','JTF_FM_API_DEBUG_MESSAGE');
1823: FND_MESSAGE.Set_Token('ARG1',l_full_name||': End');
1824: FND_MSG_PUB.Add;
1825: END IF; -- IF FND_MSG.PUB.Check_Msg_level
1826:
1827: --Standard call to get message count and if count=1, get the message