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.CAC_VIEW_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: cac_view_wf_pvt.processinvitation(p_api_version => 1.0
2029: ,p_init_msg_list => 'T'

Line 2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2290: IF NOT FND_API.Compatible_API_Call( l_api_version

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

Line 2296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2302: IF FND_API.To_Boolean(p_init_msg_list)

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

Line 2310: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2375: IF FND_API.To_Boolean(p_commit)

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

Line 2387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

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

Line 2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2720: IF NOT FND_API.Compatible_API_Call( l_api_version

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

Line 2726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2732: IF FND_API.To_Boolean(p_init_msg_list)

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

Line 2740: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2774: , p_init_msg_list => fnd_api.g_false

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

Line 2775: , p_commit => fnd_api.g_true

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

Line 2788: IF FND_API.To_Boolean(p_commit)

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

Line 2812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

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

Line 2814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2943: IF NOT FND_API.Compatible_API_Call( l_api_version

2939:
2940: /*****************************************************************************
2941: ** Standard call to check for call compatibility
2942: *****************************************************************************/
2943: IF NOT FND_API.Compatible_API_Call( l_api_version
2944: , p_api_version
2945: , l_api_name
2946: , G_PKG_NAME
2947: )

Line 2949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2945: , l_api_name
2946: , G_PKG_NAME
2947: )
2948: THEN
2949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2950: END IF;
2951:
2952: /*****************************************************************************
2953: ** Initialize message list if p_init_msg_list is set to TRUE

Line 2955: IF FND_API.To_Boolean(p_init_msg_list)

2951:
2952: /*****************************************************************************
2953: ** Initialize message list if p_init_msg_list is set to TRUE
2954: *****************************************************************************/
2955: IF FND_API.To_Boolean(p_init_msg_list)
2956: THEN
2957: FND_MSG_PUB.Initialize;
2958: END IF;
2959:

Line 2963: x_return_status := FND_API.G_RET_STS_SUCCESS;

2959:
2960: /*****************************************************************************
2961: ** Initialize API return status to success
2962: *****************************************************************************/
2963: x_return_status := FND_API.G_RET_STS_SUCCESS;
2964:
2965: /*****************************************************************************
2966: ** Get Appointment details for every invitee and start a notification WF for
2967: ** all of them.

Line 2973: RAISE fnd_api.g_exc_unexpected_error;

2969: OPEN c_invitor (p_TaskID);
2970: FETCH c_invitor INTO l_invitor;
2971: IF c_invitor%NOTFOUND THEN
2972: CLOSE c_invitor;
2973: RAISE fnd_api.g_exc_unexpected_error;
2974: END IF;
2975: CLOSE c_invitor;
2976:
2977: FOR r_Task IN c_Task(p_TaskID, p_INVITEE, p_INVITEE_TYPE)

Line 3086: IF FND_API.To_Boolean(p_commit)

3082: ** Standard check of p_commit (WF won't start until commited)
3083: ***************************************************************************/
3084:
3085:
3086: IF FND_API.To_Boolean(p_commit)
3087: THEN
3088: COMMIT WORK;
3089: END IF;
3090: /***************************************************************************

Line 3093: IF FND_API.To_Boolean(p_commit)

3089: END IF;
3090: /***************************************************************************
3091: ** Standard check of p_commit (WF won't start until commited)
3092: ***************************************************************************/
3093: IF FND_API.To_Boolean(p_commit)
3094: THEN
3095: COMMIT WORK;
3096: END IF;
3097:

Line 3107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

3103: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3104: , p_data => x_msg_data
3105: );
3106: EXCEPTION
3107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3108: THEN
3109:
3110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3111: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 3110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3106: EXCEPTION
3107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3108: THEN
3109:
3110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3111: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3112: , p_data => x_msg_data
3113: );
3114: WHEN OTHERS

Line 3117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3113: );
3114: WHEN OTHERS
3115: THEN
3116:
3117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3118: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3119: THEN
3120: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
3121: , l_api_name

Line 3402: IF NOT FND_API.Compatible_API_Call( l_api_version

3398:
3399: /*****************************************************************************
3400: ** Standard call to check for call compatibility
3401: *****************************************************************************/
3402: IF NOT FND_API.Compatible_API_Call( l_api_version
3403: , p_api_version
3404: , l_api_name
3405: , G_PKG_NAME
3406: )

Line 3408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3404: , l_api_name
3405: , G_PKG_NAME
3406: )
3407: THEN
3408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3409: END IF;
3410:
3411: /*****************************************************************************
3412: ** Initialize message list if p_init_msg_list is set to TRUE

Line 3414: IF FND_API.To_Boolean(p_init_msg_list)

3410:
3411: /*****************************************************************************
3412: ** Initialize message list if p_init_msg_list is set to TRUE
3413: *****************************************************************************/
3414: IF FND_API.To_Boolean(p_init_msg_list)
3415: THEN
3416: FND_MSG_PUB.Initialize;
3417: END IF;
3418:

Line 3422: x_return_status := FND_API.G_RET_STS_SUCCESS;

3418:
3419: /*****************************************************************************
3420: ** Initialize API return status to success
3421: *****************************************************************************/
3422: x_return_status := FND_API.G_RET_STS_SUCCESS;
3423:
3424: /*****************************************************************************
3425: ** Get Appointment details for every invitee and start a notification WF for
3426: ** all of them.

Line 3432: RAISE fnd_api.g_exc_unexpected_error;

3428: OPEN c_invitor (p_TaskID);
3429: FETCH c_invitor INTO l_invitor;
3430: IF c_invitor%NOTFOUND THEN
3431: CLOSE c_invitor;
3432: RAISE fnd_api.g_exc_unexpected_error;
3433: END IF;
3434: CLOSE c_invitor;
3435:
3436: FOR r_Task IN c_Task(p_TaskID, p_INVITEE, p_INVITEE_TYPE)

Line 3545: IF FND_API.To_Boolean(p_commit)

3541: ** Standard check of p_commit (WF won't start until commited)
3542: ***************************************************************************/
3543:
3544:
3545: IF FND_API.To_Boolean(p_commit)
3546: THEN
3547: COMMIT WORK;
3548: END IF;
3549: /***************************************************************************

Line 3552: IF FND_API.To_Boolean(p_commit)

3548: END IF;
3549: /***************************************************************************
3550: ** Standard check of p_commit (WF won't start until commited)
3551: ***************************************************************************/
3552: IF FND_API.To_Boolean(p_commit)
3553: THEN
3554: COMMIT WORK;
3555: END IF;
3556:

Line 3566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

3562: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3563: , p_data => x_msg_data
3564: );
3565: EXCEPTION
3566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3567: THEN
3568:
3569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3570: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 3569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3565: EXCEPTION
3566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3567: THEN
3568:
3569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3570: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3571: , p_data => x_msg_data
3572: );
3573: WHEN OTHERS

Line 3576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3572: );
3573: WHEN OTHERS
3574: THEN
3575:
3576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3577: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3578: THEN
3579: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
3580: , l_api_name

Line 3783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3779: ELSE
3780: /***************************************************************************
3781: ** Unknown function from WF - raise error
3782: ***************************************************************************/
3783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3784: END IF;
3785:
3786: EXCEPTION
3787: WHEN OTHERS