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.JTF_CAL_WF_PVT dependencies on FND_API

Line 299: IF NOT FND_API.Compatible_API_Call( l_api_version

295: BEGIN
296: /*****************************************************************************
297: ** Standard call to check for call compatibility
298: *****************************************************************************/
299: IF NOT FND_API.Compatible_API_Call( l_api_version
300: , p_api_version
301: , l_api_name
302: , G_PKG_NAME
303: )

Line 305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

301: , l_api_name
302: , G_PKG_NAME
303: )
304: THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: END IF;
307:
308: /*****************************************************************************
309: ** Initialize message list if p_init_msg_list is set to TRUE

Line 311: IF FND_API.To_Boolean(p_init_msg_list)

307:
308: /*****************************************************************************
309: ** Initialize message list if p_init_msg_list is set to TRUE
310: *****************************************************************************/
311: IF FND_API.To_Boolean(p_init_msg_list)
312: THEN
313: FND_MSG_PUB.Initialize;
314: END IF;
315:

Line 319: x_return_status := FND_API.G_RET_STS_SUCCESS;

315:
316: /*****************************************************************************
317: ** Initialize API return status to success
318: *****************************************************************************/
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320:
321: /***************************************************************************
322: ** we need an itemkey
323: ***************************************************************************/

Line 471: IF FND_API.To_Boolean(p_commit)

467:
468: /***************************************************************************
469: ** Standard check of p_commit (WF won't start until commited)
470: ***************************************************************************/
471: IF FND_API.To_Boolean(p_commit)
472: THEN
473: COMMIT WORK;
474: END IF;
475:

Line 484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

480: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
481: , p_data => x_msg_data
482: );
483: EXCEPTION
484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
485: THEN
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
487: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
488: , p_data => x_msg_data);

Line 486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

482: );
483: EXCEPTION
484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
485: THEN
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
487: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
488: , p_data => x_msg_data);
489: WHEN OTHERS
490: THEN

Line 491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

487: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
488: , p_data => x_msg_data);
489: WHEN OTHERS
490: THEN
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
493: THEN
494: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
495: , l_api_name

Line 575: IF NOT FND_API.Compatible_API_Call( l_api_version

571: BEGIN
572: /*****************************************************************************
573: ** Standard call to check for call compatibility
574: *****************************************************************************/
575: IF NOT FND_API.Compatible_API_Call( l_api_version
576: , p_api_version
577: , l_api_name
578: , G_PKG_NAME
579: )

Line 581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

577: , l_api_name
578: , G_PKG_NAME
579: )
580: THEN
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: END IF;
583: /*****************************************************************************
584: ** Initialize message list if p_init_msg_list is set to TRUE
585: *****************************************************************************/

Line 586: IF FND_API.To_Boolean(p_init_msg_list)

582: END IF;
583: /*****************************************************************************
584: ** Initialize message list if p_init_msg_list is set to TRUE
585: *****************************************************************************/
586: IF FND_API.To_Boolean(p_init_msg_list)
587: THEN
588: FND_MSG_PUB.Initialize;
589: END IF;
590:

Line 594: x_return_status := FND_API.G_RET_STS_SUCCESS;

590:
591: /*****************************************************************************
592: ** Initialize API return status to success
593: *****************************************************************************/
594: x_return_status := FND_API.G_RET_STS_SUCCESS;
595:
596: /***************************************************************************
597: ** we need an itemkey
598: ***************************************************************************/

Line 607: x_return_status := fnd_api.g_ret_sts_unexp_error;

603: IF (p_assignment_status_id <> 3 AND p_assignment_status_id <>4) THEN
604: fnd_message.set_name ('JTF', 'JTF_CAL_INVALID_ASSIGNMENT');
605: fnd_message.set_token ('ASSIGNMENT_STATUS_ID', p_assignment_status_id);
606: fnd_msg_pub.add;
607: x_return_status := fnd_api.g_ret_sts_unexp_error;
608: RAISE fnd_api.g_exc_unexpected_error;
609: END IF;
610:
611: OPEN c_invitor (p_task_assignment_id);

Line 608: RAISE fnd_api.g_exc_unexpected_error;

604: fnd_message.set_name ('JTF', 'JTF_CAL_INVALID_ASSIGNMENT');
605: fnd_message.set_token ('ASSIGNMENT_STATUS_ID', p_assignment_status_id);
606: fnd_msg_pub.add;
607: x_return_status := fnd_api.g_ret_sts_unexp_error;
608: RAISE fnd_api.g_exc_unexpected_error;
609: END IF;
610:
611: OPEN c_invitor (p_task_assignment_id);
612: FETCH c_invitor INTO l_invitor;

Line 615: RAISE fnd_api.g_exc_unexpected_error;

611: OPEN c_invitor (p_task_assignment_id);
612: FETCH c_invitor INTO l_invitor;
613: IF c_invitor%NOTFOUND THEN
614: CLOSE c_invitor;
615: RAISE fnd_api.g_exc_unexpected_error;
616: END IF;
617: CLOSE c_invitor;
618:
619:

Line 715: IF FND_API.To_Boolean(p_commit)

711: );
712: /***************************************************************************
713: ** Standard check of p_commit (WF won't start until commited)
714: ***************************************************************************/
715: IF FND_API.To_Boolean(p_commit)
716: THEN
717: COMMIT WORK;
718: END IF;
719:

Line 728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

724: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
725: , p_data => x_msg_data
726: );
727: EXCEPTION
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
729: THEN
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
732: , p_data => x_msg_data);

Line 730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

726: );
727: EXCEPTION
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
729: THEN
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
732: , p_data => x_msg_data);
733: WHEN OTHERS
734: THEN

Line 735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

731: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
732: , p_data => x_msg_data);
733: WHEN OTHERS
734: THEN
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
737: THEN
738: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
739: , l_api_name

Line 793: l_return_status := FND_API.G_RET_STS_SUCCESS;

789: BEGIN
790: /*****************************************************************************
791: ** Initialize API return status to success
792: *****************************************************************************/
793: l_return_status := FND_API.G_RET_STS_SUCCESS;
794:
795: /*****************************************************************************
796: ** Get the WF attribute values
797: *****************************************************************************/

Line 881: IF (l_return_status <> FND_API.G_TRUE)

877: );
878:
879: END IF;
880:
881: IF (l_return_status <> FND_API.G_TRUE)
882: THEN
883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
884: END IF;
885:

Line 883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

879: END IF;
880:
881: IF (l_return_status <> FND_API.G_TRUE)
882: THEN
883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
884: END IF;
885:
886: resultout := 'COMPLETE:NO_ERROR';
887:

Line 962: IF NOT FND_API.Compatible_API_Call( l_api_version

958: BEGIN
959: /*****************************************************************************
960: ** Standard call to check for call compatibility
961: *****************************************************************************/
962: IF NOT FND_API.Compatible_API_Call( l_api_version
963: , p_api_version
964: , l_api_name
965: , G_PKG_NAME
966: )

Line 968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

964: , l_api_name
965: , G_PKG_NAME
966: )
967: THEN
968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
969: END IF;
970:
971: /*****************************************************************************
972: ** Initialize message list if p_init_msg_list is set to TRUE

Line 974: IF FND_API.To_Boolean(p_init_msg_list)

970:
971: /*****************************************************************************
972: ** Initialize message list if p_init_msg_list is set to TRUE
973: *****************************************************************************/
974: IF FND_API.To_Boolean(p_init_msg_list)
975: THEN
976: FND_MSG_PUB.Initialize;
977: END IF;
978:

Line 982: x_return_status := FND_API.G_RET_STS_SUCCESS;

978:
979: /*****************************************************************************
980: ** Initialize API return status to success
981: *****************************************************************************/
982: x_return_status := FND_API.G_RET_STS_SUCCESS;
983:
984: /*****************************************************************************
985: ** Look up the Calendar Administrator from the Profile (this should be an
986: ** existing WF_ROLE)

Line 1072: IF FND_API.To_Boolean(p_commit)

1068:
1069: /***************************************************************************
1070: ** Standard check of p_commit (WF won't start until commited..)
1071: ***************************************************************************/
1072: IF FND_API.To_Boolean(p_commit)
1073: THEN
1074: COMMIT WORK;
1075: END IF;
1076:

Line 1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1081: , p_data => x_msg_data
1082: );
1083:
1084: EXCEPTION
1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1086: THEN
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1089: , p_data => x_msg_data

Line 1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1083:
1084: EXCEPTION
1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1086: THEN
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1089: , p_data => x_msg_data
1090: );
1091: WHEN OTHERS

Line 1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1089: , p_data => x_msg_data
1090: );
1091: WHEN OTHERS
1092: THEN
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1095: THEN
1096: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1097: , l_api_name

Line 1192: l_return_status := FND_API.G_RET_STS_SUCCESS;

1188:
1189: /*****************************************************************************
1190: ** Initialize API return status to success
1191: *****************************************************************************/
1192: l_return_status := FND_API.G_RET_STS_SUCCESS;
1193:
1194: /*****************************************************************************
1195: ** Get the WF attribute values
1196: *****************************************************************************/

Line 1249: , P_INIT_MSG_LIST => FND_API.G_TRUE

1245: ** No Group exists with this name/description, assume it's a new one.
1246: *************************************************************************/
1247: JTF_RS_GROUPS_PUB.Create_Resource_Group
1248: ( P_API_VERSION => 1.0
1249: , P_INIT_MSG_LIST => FND_API.G_TRUE
1250: , P_COMMIT => FND_API.G_FALSE -- Can't commit in WF!
1251: , P_GROUP_NAME => l_GroupName
1252: , P_GROUP_DESC => l_GroupDescription
1253: , P_START_DATE_ACTIVE => SYSDATE

Line 1250: , P_COMMIT => FND_API.G_FALSE -- Can't commit in WF!

1246: *************************************************************************/
1247: JTF_RS_GROUPS_PUB.Create_Resource_Group
1248: ( P_API_VERSION => 1.0
1249: , P_INIT_MSG_LIST => FND_API.G_TRUE
1250: , P_COMMIT => FND_API.G_FALSE -- Can't commit in WF!
1251: , P_GROUP_NAME => l_GroupName
1252: , P_GROUP_DESC => l_GroupDescription
1253: , P_START_DATE_ACTIVE => SYSDATE
1254: , X_RETURN_STATUS => l_return_status

Line 1269: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1265: *************************************************************************/
1266: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1267: , p_data => l_msg_data
1268: );
1269: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1270: THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: END IF;
1273: END IF;

Line 1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1267: , p_data => l_msg_data
1268: );
1269: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1270: THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: END IF;
1273: END IF;
1274:
1275: IF (c_GroupExists%ISOPEN)

Line 1309: , P_INIT_MSG_LIST => FND_API.G_FALSE

1305: ** Create the usage
1306: ***************************************************************************/
1307: JTF_RS_GROUP_USAGES_PUB.Create_Group_Usage
1308: ( P_API_VERSION => 1.0
1309: , P_INIT_MSG_LIST => FND_API.G_FALSE
1310: , P_COMMIT => FND_API.G_FALSE
1311: , P_GROUP_ID => l_GroupID
1312: , P_GROUP_NUMBER => NULL
1313: , P_USAGE => l_usage

Line 1310: , P_COMMIT => FND_API.G_FALSE

1306: ***************************************************************************/
1307: JTF_RS_GROUP_USAGES_PUB.Create_Group_Usage
1308: ( P_API_VERSION => 1.0
1309: , P_INIT_MSG_LIST => FND_API.G_FALSE
1310: , P_COMMIT => FND_API.G_FALSE
1311: , P_GROUP_ID => l_GroupID
1312: , P_GROUP_NUMBER => NULL
1313: , P_USAGE => l_usage
1314: , X_RETURN_STATUS => l_return_status

Line 1326: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1322: ***************************************************************************/
1323: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1324: , p_data => l_msg_data
1325: );
1326: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1327: THEN
1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1329: END IF;
1330: --END IF;

Line 1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1324: , p_data => l_msg_data
1325: );
1326: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1327: THEN
1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1329: END IF;
1330: --END IF;
1331:
1332: /*IF (c_GroupUsageExists%ISOPEN)

Line 1338: l_return_status := FND_API.G_TRUE;

1334: CLOSE c_GroupUsageExists;
1335: END IF;
1336: */
1337:
1338: l_return_status := FND_API.G_TRUE;
1339:
1340: /*****************************************************************************
1341: ** Grant Administrator privs to the requestor
1342: *****************************************************************************/

Line 1381: IF (l_return_status <> FND_API.G_TRUE)

1377: , x_success => l_return_status
1378: , x_errorcode => l_msg_data
1379: );
1380:
1381: IF (l_return_status <> FND_API.G_TRUE)
1382: THEN
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: END IF;
1385:

Line 1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1379: );
1380:
1381: IF (l_return_status <> FND_API.G_TRUE)
1382: THEN
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: END IF;
1385:
1386: END IF; -- End of c_GroupUsageExists%NOTFOUND
1387:

Line 1500: IF NOT FND_API.Compatible_API_Call( l_api_version

1496: BEGIN
1497: /*****************************************************************************
1498: ** Standard call to check for call compatibility
1499: *****************************************************************************/
1500: IF NOT FND_API.Compatible_API_Call( l_api_version
1501: , p_api_version
1502: , l_api_name
1503: , G_PKG_NAME
1504: )

Line 1506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1502: , l_api_name
1503: , G_PKG_NAME
1504: )
1505: THEN
1506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1507: END IF;
1508:
1509: /*****************************************************************************
1510: ** Initialize message list if p_init_msg_list is set to TRUE

Line 1512: IF FND_API.To_Boolean(p_init_msg_list)

1508:
1509: /*****************************************************************************
1510: ** Initialize message list if p_init_msg_list is set to TRUE
1511: *****************************************************************************/
1512: IF FND_API.To_Boolean(p_init_msg_list)
1513: THEN
1514: FND_MSG_PUB.Initialize;
1515: END IF;
1516:

Line 1520: x_return_status := FND_API.G_RET_STS_SUCCESS;

1516:
1517: /*****************************************************************************
1518: ** Initialize API return status to success
1519: *****************************************************************************/
1520: x_return_status := FND_API.G_RET_STS_SUCCESS;
1521:
1522: /*****************************************************************************
1523: ** Look up the Calendar Administrator from the Profile (this should be an
1524: ** existing WF_ROLE)

Line 1632: IF FND_API.To_Boolean(p_commit)

1628:
1629: /***************************************************************************
1630: ** Standard check of p_commit (WF won't start until commited)
1631: ***************************************************************************/
1632: IF FND_API.To_Boolean(p_commit)
1633: THEN
1634: COMMIT WORK;
1635: END IF;
1636:

Line 1647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1643: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1644: , p_data => x_msg_data
1645: );
1646: EXCEPTION
1647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1648: THEN
1649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1650: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1651: , p_data => x_msg_data

Line 1649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1645: );
1646: EXCEPTION
1647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1648: THEN
1649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1650: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1651: , p_data => x_msg_data
1652: );
1653: WHEN OTHERS

Line 1655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1651: , p_data => x_msg_data
1652: );
1653: WHEN OTHERS
1654: THEN
1655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1656: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1657: THEN
1658: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1659: , l_api_name

Line 1749: IF NOT FND_API.Compatible_API_Call( l_api_version

1745: BEGIN
1746: /*****************************************************************************
1747: ** Standard call to check for call compatibility
1748: *****************************************************************************/
1749: IF NOT FND_API.Compatible_API_Call( l_api_version
1750: , p_api_version
1751: , l_api_name
1752: , G_PKG_NAME
1753: )

Line 1755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1751: , l_api_name
1752: , G_PKG_NAME
1753: )
1754: THEN
1755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1756: END IF;
1757:
1758: /*****************************************************************************
1759: ** Initialize message list if p_init_msg_list is set to TRUE

Line 1761: IF FND_API.To_Boolean(p_init_msg_list)

1757:
1758: /*****************************************************************************
1759: ** Initialize message list if p_init_msg_list is set to TRUE
1760: *****************************************************************************/
1761: IF FND_API.To_Boolean(p_init_msg_list)
1762: THEN
1763: FND_MSG_PUB.Initialize;
1764: END IF;
1765:

Line 1769: x_return_status := FND_API.G_RET_STS_SUCCESS;

1765:
1766: /*****************************************************************************
1767: ** Initialize API return status to success
1768: *****************************************************************************/
1769: x_return_status := FND_API.G_RET_STS_SUCCESS;
1770:
1771: /*****************************************************************************
1772: ** Look up the Calendar Administrator from the Profile (this should be an
1773: ** existing WF_ROLE)

Line 1881: IF FND_API.To_Boolean(p_commit)

1877:
1878: /***************************************************************************
1879: ** Standard check of p_commit (WF won't start until commited)
1880: ***************************************************************************/
1881: IF FND_API.To_Boolean(p_commit)
1882: THEN
1883: COMMIT WORK;
1884: END IF;
1885:

Line 1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1892: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1893: , p_data => x_msg_data
1894: );
1895: EXCEPTION
1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1897: THEN
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1899: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1900: , p_data => x_msg_data

Line 1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1894: );
1895: EXCEPTION
1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1897: THEN
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1899: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1900: , p_data => x_msg_data
1901: );
1902: WHEN OTHERS

Line 1904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1900: , p_data => x_msg_data
1901: );
1902: WHEN OTHERS
1903: THEN
1904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1905: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1906: THEN
1907: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1908: , l_api_name

Line 2012: p_schedule_flag => fnd_api.g_miss_char, --Y Or N??

2008: p_init_msg_list => 'T', --?
2009: p_task_assignment_id => l_task_assignment_id,
2010: p_resource_type_code => l_resource_type,
2011: p_resource_id => l_InviteeResourceID,
2012: p_schedule_flag => fnd_api.g_miss_char, --Y Or N??
2013: p_actual_start_date => null, --?
2014: p_actual_end_date => null, --?
2015: p_assignment_status_id => l_assignment_status_id,
2016: p_show_on_calendar => 'Y',

Line 2025: IF l_return_status = fnd_api.g_ret_sts_success

2021: x_msg_data => l_msg_data
2022: ) ;
2023:
2024:
2025: IF l_return_status = fnd_api.g_ret_sts_success
2026: THEN
2027:
2028: jtf_cal_wf_pvt.processinvitation(p_api_version => 1.0
2029: ,p_init_msg_list => 'T'

Line 2150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2146: IF ((l_InvitorWFRole IS NULL) OR
2147: (l_InvitorWFName IS NULL)
2148: )
2149: THEN
2150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2151: ELSE
2152: /*************************************************************************
2153: ** Found INVITOR, set WF Attributes
2154: *************************************************************************/

Line 2221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2217: ELSE
2218: /***************************************************************************
2219: ** Unknown function from WF - raise error
2220: ***************************************************************************/
2221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: END IF;
2223:
2224: EXCEPTION
2225: WHEN OTHERS

Line 2287: IF NOT FND_API.Compatible_API_Call( l_api_version

2283: BEGIN
2284: /*****************************************************************************
2285: ** Standard call to check for call compatibility
2286: *****************************************************************************/
2287: IF NOT FND_API.Compatible_API_Call( l_api_version
2288: , p_api_version
2289: , l_api_name
2290: , G_PKG_NAME
2291: )

Line 2293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2289: , l_api_name
2290: , G_PKG_NAME
2291: )
2292: THEN
2293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2294: END IF;
2295:
2296: /*****************************************************************************
2297: ** Initialize message list if p_init_msg_list is set to TRUE

Line 2299: IF FND_API.To_Boolean(p_init_msg_list)

2295:
2296: /*****************************************************************************
2297: ** Initialize message list if p_init_msg_list is set to TRUE
2298: *****************************************************************************/
2299: IF FND_API.To_Boolean(p_init_msg_list)
2300: THEN
2301: FND_MSG_PUB.Initialize;
2302: END IF;
2303:

Line 2307: x_return_status := FND_API.G_RET_STS_SUCCESS;

2303:
2304: /*****************************************************************************
2305: ** Initialize API return status to success
2306: *****************************************************************************/
2307: x_return_status := FND_API.G_RET_STS_SUCCESS;
2308:
2309: /*****************************************************************************
2310: ** Look up the Calendar Administrator from the Profile (this should be an
2311: ** existing WF_ROLE)

Line 2372: IF FND_API.To_Boolean(p_commit)

2368:
2369: /***************************************************************************
2370: ** Standard check of p_commit (WF won't start until commited)
2371: ***************************************************************************/
2372: IF FND_API.To_Boolean(p_commit)
2373: THEN
2374: COMMIT WORK;
2375: END IF;
2376:

Line 2384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

2380: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2381: , p_data => x_msg_data
2382: );
2383: EXCEPTION
2384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2385: THEN
2386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2387: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2388: , p_data => x_msg_data

Line 2386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2382: );
2383: EXCEPTION
2384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2385: THEN
2386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2387: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2388: , p_data => x_msg_data
2389: );
2390: WHEN OTHERS

Line 2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2388: , p_data => x_msg_data
2389: );
2390: WHEN OTHERS
2391: THEN
2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2393: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2394: THEN
2395: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
2396: , l_api_name

Line 2717: IF NOT FND_API.Compatible_API_Call( l_api_version

2713: BEGIN
2714: /*****************************************************************************
2715: ** Standard call to check for call compatibility
2716: *****************************************************************************/
2717: IF NOT FND_API.Compatible_API_Call( l_api_version
2718: , p_api_version
2719: , l_api_name
2720: , G_PKG_NAME
2721: )

Line 2723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2719: , l_api_name
2720: , G_PKG_NAME
2721: )
2722: THEN
2723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2724: END IF;
2725:
2726: /*****************************************************************************
2727: ** Initialize message list if p_init_msg_list is set to TRUE

Line 2729: IF FND_API.To_Boolean(p_init_msg_list)

2725:
2726: /*****************************************************************************
2727: ** Initialize message list if p_init_msg_list is set to TRUE
2728: *****************************************************************************/
2729: IF FND_API.To_Boolean(p_init_msg_list)
2730: THEN
2731: FND_MSG_PUB.Initialize;
2732: END IF;
2733:

Line 2737: x_return_status := FND_API.G_RET_STS_SUCCESS;

2733:
2734: /*****************************************************************************
2735: ** Initialize API return status to success
2736: *****************************************************************************/
2737: x_return_status := FND_API.G_RET_STS_SUCCESS;
2738:
2739: /*****************************************************************************
2740: ** Get Appointment details for every invitee and start a notification WF for
2741: ** all of them.

Line 2771: , p_init_msg_list => fnd_api.g_false

2767: END IF;
2768: --Check if this is an update to Do Not Remind me
2769: IF p_RemindDate IS NOT NULL THEN
2770: StartReminders( p_api_version => 1.0
2771: , p_init_msg_list => fnd_api.g_false
2772: , p_commit => fnd_api.g_true
2773: , x_return_status => l_return_status
2774: , x_msg_count => l_msg_count
2775: , x_msg_data => l_msg_data

Line 2772: , p_commit => fnd_api.g_true

2768: --Check if this is an update to Do Not Remind me
2769: IF p_RemindDate IS NOT NULL THEN
2770: StartReminders( p_api_version => 1.0
2771: , p_init_msg_list => fnd_api.g_false
2772: , p_commit => fnd_api.g_true
2773: , x_return_status => l_return_status
2774: , x_msg_count => l_msg_count
2775: , x_msg_data => l_msg_data
2776: , p_INVITOR => r_Task.INVITOR

Line 2785: IF FND_API.To_Boolean(p_commit)

2781:
2782: /***************************************************************************
2783: ** Standard check of p_commit (WF won't start until commited)
2784: ***************************************************************************/
2785: IF FND_API.To_Boolean(p_commit)
2786: THEN
2787: COMMIT WORK;
2788: END IF;
2789:

Line 2809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

2805: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2806: , p_data => x_msg_data
2807: );
2808: EXCEPTION
2809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2810: THEN
2811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2812: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2813: , p_data => x_msg_data

Line 2811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2807: );
2808: EXCEPTION
2809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2810: THEN
2811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2812: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2813: , p_data => x_msg_data
2814: );
2815: WHEN OTHERS

Line 2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2813: , p_data => x_msg_data
2814: );
2815: WHEN OTHERS
2816: THEN
2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2818: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2819: THEN
2820: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
2821: , l_api_name

Line 3177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3173: ELSE
3174: /***************************************************************************
3175: ** Unknown function from WF - raise error
3176: ***************************************************************************/
3177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3178: END IF;
3179:
3180: EXCEPTION
3181: WHEN OTHERS