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_EC_WORKFLOW_PKG dependencies on FND_API

Line 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

76: BEGIN
77:
78: -- doesn't perform a role validation
79:
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: jtf_ec_workflow_pkg.NotifList(i+1).name := p_role_name;
83:
84: EXCEPTION

Line 85: WHEN FND_API.G_EXC_ERROR THEN

81:
82: jtf_ec_workflow_pkg.NotifList(i+1).name := p_role_name;
83:
84: EXCEPTION
85: WHEN FND_API.G_EXC_ERROR THEN
86: x_return_status := FND_API.G_Ret_Sts_Error;
87: WHEN OTHERS THEN
88:
89: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 86: x_return_status := FND_API.G_Ret_Sts_Error;

82: jtf_ec_workflow_pkg.NotifList(i+1).name := p_role_name;
83:
84: EXCEPTION
85: WHEN FND_API.G_EXC_ERROR THEN
86: x_return_status := FND_API.G_Ret_Sts_Error;
87: WHEN OTHERS THEN
88:
89: x_return_status := fnd_api.g_ret_sts_unexp_error;
90: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 89: x_return_status := fnd_api.g_ret_sts_unexp_error;

85: WHEN FND_API.G_EXC_ERROR THEN
86: x_return_status := FND_API.G_Ret_Sts_Error;
87: WHEN OTHERS THEN
88:
89: x_return_status := fnd_api.g_ret_sts_unexp_error;
90: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
91: then FND_MSG_PUB.Add_Exc_Msg
92: (G_PKG_NAME,
93: l_api_name

Line 122: x_return_status := FND_API.G_RET_STS_SUCCESS;

118: AND user_id = p_user_id;
119:
120: BEGIN
121:
122: x_return_status := FND_API.G_RET_STS_SUCCESS;
123:
124: open c_user_name(p_user_id);
125: fetch c_user_name into x_user_name;
126: if c_user_name%NOTFOUND then

Line 132: WHEN FND_API.G_EXC_ERROR THEN

128: end if;
129: close c_user_name;
130:
131: EXCEPTION
132: WHEN FND_API.G_EXC_ERROR THEN
133: x_return_status := FND_API.G_Ret_Sts_Error;
134: WHEN OTHERS THEN
135:
136: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 133: x_return_status := FND_API.G_Ret_Sts_Error;

129: close c_user_name;
130:
131: EXCEPTION
132: WHEN FND_API.G_EXC_ERROR THEN
133: x_return_status := FND_API.G_Ret_Sts_Error;
134: WHEN OTHERS THEN
135:
136: x_return_status := fnd_api.g_ret_sts_unexp_error;
137: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 136: x_return_status := fnd_api.g_ret_sts_unexp_error;

132: WHEN FND_API.G_EXC_ERROR THEN
133: x_return_status := FND_API.G_Ret_Sts_Error;
134: WHEN OTHERS THEN
135:
136: x_return_status := fnd_api.g_ret_sts_unexp_error;
137: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
138: then FND_MSG_PUB.Add_Exc_Msg
139: (G_PKG_NAME,
140: l_api_name

Line 216: x_return_status := FND_API.G_RET_STS_SUCCESS;

212: FROM css_def_defects_all
213: WHERE defect_number = p_doc_number; */
214:
215: BEGIN
216: x_return_status := FND_API.G_RET_STS_SUCCESS;
217:
218: if p_doc_type = 'TASK' then
219:
220: open c_get_task_owner_id;

Line 342: WHEN FND_API.G_EXC_ERROR THEN

338: end if;
339: end if;
340:
341: EXCEPTION
342: WHEN FND_API.G_EXC_ERROR THEN
343: x_return_status := FND_API.G_Ret_Sts_Error;
344: WHEN OTHERS THEN
345:
346: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 343: x_return_status := FND_API.G_Ret_Sts_Error;

339: end if;
340:
341: EXCEPTION
342: WHEN FND_API.G_EXC_ERROR THEN
343: x_return_status := FND_API.G_Ret_Sts_Error;
344: WHEN OTHERS THEN
345:
346: x_return_status := fnd_api.g_ret_sts_unexp_error;
347: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 346: x_return_status := fnd_api.g_ret_sts_unexp_error;

342: WHEN FND_API.G_EXC_ERROR THEN
343: x_return_status := FND_API.G_Ret_Sts_Error;
344: WHEN OTHERS THEN
345:
346: x_return_status := fnd_api.g_ret_sts_unexp_error;
347: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
348: then FND_MSG_PUB.Add_Exc_Msg
349: (G_PKG_NAME,
350: l_api_name

Line 681: x_return_status := FND_API.G_RET_STS_SUCCESS;

677: AND tr.object_type_code = jo.object_code
678: AND tr.reference_code = 'ESC';
679:
680: BEGIN
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682:
683: for details_rec in get_doc_details loop
684: l_object_number := details_rec.object_number;
685:

Line 693: AND l_temp_status <> FND_API.G_RET_STS_SUCCESS

689: x_person_name => l_person_name,
690: x_return_status => l_temp_status);
691:
692: if fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_debug_medium )
693: AND l_temp_status <> FND_API.G_RET_STS_SUCCESS
694: then
695: fnd_message.set_name ('JTF', 'JTF_EC_DET_ERROR');
696: fnd_msg_pub.Add;
697: end if;

Line 717: x_return_status := fnd_api.g_ret_sts_unexp_error;

713: EXCEPTION
714:
715: WHEN OTHERS THEN
716:
717: x_return_status := fnd_api.g_ret_sts_unexp_error;
718:
719: if FND_MSG_PUB.Check_Msg_Level
720: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: then

Line 737: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,

733: ---------------------------------------------------------------------------
734:
735: PROCEDURE SetNotifList(p_task_id IN NUMBER,
736: p_owner_id IN NUMBER,
737: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
738: p_owner_type_code IN VARCHAR2,
739: p_old_owner_type_code IN VARCHAR2,
740: x_row_number OUT NOCOPY NUMBER,
741: x_return_status OUT NOCOPY VARCHAR2) Is

Line 797: x_return_status := FND_API.G_RET_STS_SUCCESS;

793: WHERE resource_id = p_resource_id;
794:
795: BEGIN
796:
797: x_return_status := FND_API.G_RET_STS_SUCCESS;
798:
799: -------------------------------------------------------------------------
800: -- Include the Esc Owner in the Notification List
801: -------------------------------------------------------------------------

Line 881: if p_old_owner_id <> FND_API.G_MISS_NUM then

877: --Bug 2415943 Include Old Owner only if old_owner_type_code is RS_EMPLOYEE Start
878:
879: if (p_old_owner_type_code = 'RS_EMPLOYEE') then
880:
881: if p_old_owner_id <> FND_API.G_MISS_NUM then
882:
883: l_role_name := NULL;
884: l_name := NULL;
885:

Line 979: x_return_status := fnd_api.g_ret_sts_unexp_error;

975: EXCEPTION
976:
977: WHEN OTHERS THEN
978:
979: x_return_status := fnd_api.g_ret_sts_unexp_error;
980:
981: if FND_MSG_PUB.Check_Msg_Level
982: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
983: then

Line 998: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

994: -------------------------------------------------------------------------
995:
996: PROCEDURE Start_Resc_Workflow(
997: p_api_version IN NUMBER,
998: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
999: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1000: x_return_status OUT NOCOPY VARCHAR2,
1001: x_msg_count OUT NOCOPY NUMBER,
1002: x_msg_data OUT NOCOPY VARCHAR2,

Line 999: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

995:
996: PROCEDURE Start_Resc_Workflow(
997: p_api_version IN NUMBER,
998: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
999: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1000: x_return_status OUT NOCOPY VARCHAR2,
1001: x_msg_count OUT NOCOPY NUMBER,
1002: x_msg_data OUT NOCOPY VARCHAR2,
1003: p_task_id IN NUMBER,

Line 1004: p_doc_created IN VARCHAR2 := FND_API.G_MISS_CHAR,

1000: x_return_status OUT NOCOPY VARCHAR2,
1001: x_msg_count OUT NOCOPY NUMBER,
1002: x_msg_data OUT NOCOPY VARCHAR2,
1003: p_task_id IN NUMBER,
1004: p_doc_created IN VARCHAR2 := FND_API.G_MISS_CHAR,
1005: p_owner_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1006: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1008: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1005: p_owner_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,

1001: x_msg_count OUT NOCOPY NUMBER,
1002: x_msg_data OUT NOCOPY VARCHAR2,
1003: p_task_id IN NUMBER,
1004: p_doc_created IN VARCHAR2 := FND_API.G_MISS_CHAR,
1005: p_owner_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1006: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1008: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1006: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,

1002: x_msg_data OUT NOCOPY VARCHAR2,
1003: p_task_id IN NUMBER,
1004: p_doc_created IN VARCHAR2 := FND_API.G_MISS_CHAR,
1005: p_owner_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1006: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1008: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1007: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,

1003: p_task_id IN NUMBER,
1004: p_doc_created IN VARCHAR2 := FND_API.G_MISS_CHAR,
1005: p_owner_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1006: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1008: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
1011: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1008: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,

1004: p_doc_created IN VARCHAR2 := FND_API.G_MISS_CHAR,
1005: p_owner_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1006: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1008: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
1011: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1009: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,

1005: p_owner_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1006: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1008: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
1011: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_old_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1010: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,

1006: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1008: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
1011: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_old_status_id IN NUMBER := FND_API.G_MISS_NUM,
1014: p_old_target_date IN DATE := FND_API.G_MISS_DATE,

Line 1011: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1007: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1008: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
1011: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_old_status_id IN NUMBER := FND_API.G_MISS_NUM,
1014: p_old_target_date IN DATE := FND_API.G_MISS_DATE,
1015: p_wf_process_name IN VARCHAR2 DEFAULT 'ESC_NOTIF_PROCESS',

Line 1012: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,

1008: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
1011: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_old_status_id IN NUMBER := FND_API.G_MISS_NUM,
1014: p_old_target_date IN DATE := FND_API.G_MISS_DATE,
1015: p_wf_process_name IN VARCHAR2 DEFAULT 'ESC_NOTIF_PROCESS',
1016: p_wf_item_type_name IN VARCHAR2 DEFAULT 'JTFEC',

Line 1013: p_old_status_id IN NUMBER := FND_API.G_MISS_NUM,

1009: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
1011: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_old_status_id IN NUMBER := FND_API.G_MISS_NUM,
1014: p_old_target_date IN DATE := FND_API.G_MISS_DATE,
1015: p_wf_process_name IN VARCHAR2 DEFAULT 'ESC_NOTIF_PROCESS',
1016: p_wf_item_type_name IN VARCHAR2 DEFAULT 'JTFEC',
1017: x_notif_not_sent OUT NOCOPY VARCHAR2,

Line 1014: p_old_target_date IN DATE := FND_API.G_MISS_DATE,

1010: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
1011: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_old_status_id IN NUMBER := FND_API.G_MISS_NUM,
1014: p_old_target_date IN DATE := FND_API.G_MISS_DATE,
1015: p_wf_process_name IN VARCHAR2 DEFAULT 'ESC_NOTIF_PROCESS',
1016: p_wf_item_type_name IN VARCHAR2 DEFAULT 'JTFEC',
1017: x_notif_not_sent OUT NOCOPY VARCHAR2,
1018: x_wf_process_id OUT NOCOPY NUMBER

Line 1146: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1142:
1143: -- Standard call to check for call compatibility.
1144:
1145:
1146: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1147: p_api_version,
1148: l_api_name,
1149: G_PKG_NAME)
1150: THEN

Line 1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1147: p_api_version,
1148: l_api_name,
1149: G_PKG_NAME)
1150: THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;
1153:
1154: -- Check p_init_msg_list
1155:

Line 1157: IF FND_API.To_Boolean( p_init_msg_list ) THEN

1153:
1154: -- Check p_init_msg_list
1155:
1156:
1157: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1158: FND_MSG_PUB.initialize;
1159: END IF;
1160:
1161: -- Initialize API return status to success

Line 1163: x_return_status := FND_API.G_RET_STS_SUCCESS;

1159: END IF;
1160:
1161: -- Initialize API return status to success
1162:
1163: x_return_status := FND_API.G_RET_STS_SUCCESS;
1164:
1165:
1166: -------------------------------------------------------------------------
1167: -- parameters validation

Line 1181: raise fnd_api.g_exc_error;

1177: fnd_message.set_name ('JTF', 'JTF_EC_TASK_NOT_FOUND');
1178: fnd_message.set_token ('TASK_ID', p_task_id);
1179: -- Add message to API message list.
1180: fnd_msg_pub.Add;
1181: raise fnd_api.g_exc_error;
1182: end if;
1183: close resc_task_details;
1184:
1185: -- event validation

Line 1195: RAISE fnd_api.g_exc_error;

1191: AND (p_target_date_changed <> 'Y')
1192: then
1193: fnd_message.set_name ('JTF', 'JTF_EC_INVALID_EVENT');
1194: fnd_msg_pub.add;
1195: RAISE fnd_api.g_exc_error;
1196: end if;
1197:
1198: if (p_level_changed = 'Y') AND (p_old_level = FND_API.G_MISS_CHAR) then
1199: fnd_message.set_name ('JTF', 'JTF_EC_OLD_LEVEL');

Line 1198: if (p_level_changed = 'Y') AND (p_old_level = FND_API.G_MISS_CHAR) then

1194: fnd_msg_pub.add;
1195: RAISE fnd_api.g_exc_error;
1196: end if;
1197:
1198: if (p_level_changed = 'Y') AND (p_old_level = FND_API.G_MISS_CHAR) then
1199: fnd_message.set_name ('JTF', 'JTF_EC_OLD_LEVEL');
1200: fnd_msg_pub.add;
1201: RAISE fnd_api.g_exc_error;
1202: end if;

Line 1201: RAISE fnd_api.g_exc_error;

1197:
1198: if (p_level_changed = 'Y') AND (p_old_level = FND_API.G_MISS_CHAR) then
1199: fnd_message.set_name ('JTF', 'JTF_EC_OLD_LEVEL');
1200: fnd_msg_pub.add;
1201: RAISE fnd_api.g_exc_error;
1202: end if;
1203:
1204: if ((p_owner_changed = 'Y') AND (p_old_owner_id = FND_API.G_MISS_NUM)) then
1205: fnd_message.set_name ('JTF', 'JTF_EC_OLD_OWNER');

Line 1204: if ((p_owner_changed = 'Y') AND (p_old_owner_id = FND_API.G_MISS_NUM)) then

1200: fnd_msg_pub.add;
1201: RAISE fnd_api.g_exc_error;
1202: end if;
1203:
1204: if ((p_owner_changed = 'Y') AND (p_old_owner_id = FND_API.G_MISS_NUM)) then
1205: fnd_message.set_name ('JTF', 'JTF_EC_OLD_OWNER');
1206: fnd_msg_pub.add;
1207: RAISE fnd_api.g_exc_error;
1208: end if;

Line 1207: RAISE fnd_api.g_exc_error;

1203:
1204: if ((p_owner_changed = 'Y') AND (p_old_owner_id = FND_API.G_MISS_NUM)) then
1205: fnd_message.set_name ('JTF', 'JTF_EC_OLD_OWNER');
1206: fnd_msg_pub.add;
1207: RAISE fnd_api.g_exc_error;
1208: end if;
1209:
1210: if (p_status_changed = 'Y') AND (p_old_status_id = FND_API.G_MISS_NUM) then
1211: fnd_message.set_name ('JTF', 'JTF_EC_OLD_STATUS');

Line 1210: if (p_status_changed = 'Y') AND (p_old_status_id = FND_API.G_MISS_NUM) then

1206: fnd_msg_pub.add;
1207: RAISE fnd_api.g_exc_error;
1208: end if;
1209:
1210: if (p_status_changed = 'Y') AND (p_old_status_id = FND_API.G_MISS_NUM) then
1211: fnd_message.set_name ('JTF', 'JTF_EC_OLD_STATUS');
1212: fnd_msg_pub.add;
1213: RAISE fnd_api.g_exc_error;
1214: end if;

Line 1213: RAISE fnd_api.g_exc_error;

1209:
1210: if (p_status_changed = 'Y') AND (p_old_status_id = FND_API.G_MISS_NUM) then
1211: fnd_message.set_name ('JTF', 'JTF_EC_OLD_STATUS');
1212: fnd_msg_pub.add;
1213: RAISE fnd_api.g_exc_error;
1214: end if;
1215:
1216: if (p_target_date_changed = 'Y') AND (p_old_target_date = FND_API.G_MISS_DATE) then
1217: fnd_message.set_name ('JTF', 'JTF_EC_OLD_TARGET');

Line 1216: if (p_target_date_changed = 'Y') AND (p_old_target_date = FND_API.G_MISS_DATE) then

1212: fnd_msg_pub.add;
1213: RAISE fnd_api.g_exc_error;
1214: end if;
1215:
1216: if (p_target_date_changed = 'Y') AND (p_old_target_date = FND_API.G_MISS_DATE) then
1217: fnd_message.set_name ('JTF', 'JTF_EC_OLD_TARGET');
1218: fnd_msg_pub.add;
1219: RAISE fnd_api.g_exc_error;
1220: end if;

Line 1219: RAISE fnd_api.g_exc_error;

1215:
1216: if (p_target_date_changed = 'Y') AND (p_old_target_date = FND_API.G_MISS_DATE) then
1217: fnd_message.set_name ('JTF', 'JTF_EC_OLD_TARGET');
1218: fnd_msg_pub.add;
1219: RAISE fnd_api.g_exc_error;
1220: end if;
1221:
1222: l_owner_changed := p_owner_changed;
1223: l_level_changed := p_level_changed;

Line 1362: RAISE fnd_api.g_exc_error;

1358:
1359: if fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_debug_medium ) then
1360: fnd_message.set_name ('JTF', 'JTF_EC_ERROR');
1361: fnd_msg_pub.Add;
1362: RAISE fnd_api.g_exc_error;
1363: end if;
1364:
1365: end if;
1366:

Line 1406: if (l_temp_status <> FND_API.G_RET_STS_SUCCESS) then

1402: x_doc_details_t => l_doc_details_t,
1403: x_doc_details_h => l_doc_details_h,
1404: x_return_status => l_temp_status);
1405:
1406: if (l_temp_status <> FND_API.G_RET_STS_SUCCESS) then
1407:
1408: if fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_debug_medium ) then
1409: fnd_message.set_name ('JTF', 'JTF_EC_ERROR');
1410: fnd_msg_pub.Add;

Line 1411: RAISE fnd_api.g_exc_error;

1407:
1408: if fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_debug_medium ) then
1409: fnd_message.set_name ('JTF', 'JTF_EC_ERROR');
1410: fnd_msg_pub.Add;
1411: RAISE fnd_api.g_exc_error;
1412: end if;
1413:
1414: end if;
1415:

Line 1425: l_old_owner_id := FND_API.G_MISS_NUM;

1421: l_owner_changed := 'N';
1422: l_level_changed := 'N';
1423: l_status_changed := 'N';
1424: l_target_date_changed := 'N';
1425: l_old_owner_id := FND_API.G_MISS_NUM;
1426:
1427: if (l_notif_type = 'S') then
1428: l_event := 'ESC_DOC_CREATED_S';
1429: else -- multi document + no documents

Line 1527: l_old_owner_id := FND_API.G_MISS_NUM;

1523:
1524:
1525: elsif p_doc_created <> 'Y' then -- set the owner line of WF notification to NULL
1526:
1527: l_old_owner_id := FND_API.G_MISS_NUM;
1528: hide_owner_line(p_wf_item_type_name,l_itemkey);
1529:
1530: end if;
1531:

Line 1548: RAISE fnd_api.g_exc_error;

1544: close c_esc_status;
1545: if fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_debug_medium ) then
1546: fnd_message.set_name ('JTF', 'JTF_EC_ERROR');
1547: fnd_msg_pub.Add;
1548: RAISE fnd_api.g_exc_error;
1549: end if;
1550: end if;
1551:
1552: close c_esc_status;

Line 1586: RAISE fnd_api.g_exc_error;

1582: close c_esc_level;
1583: if fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_debug_medium ) then
1584: fnd_message.set_name ('JTF', 'JTF_EC_ERROR');
1585: fnd_msg_pub.Add;
1586: RAISE fnd_api.g_exc_error;
1587: end if;
1588: end if;
1589: close c_esc_level;
1590: */

Line 1598: RAISE fnd_api.g_exc_error;

1594: close c_esc_old_level;
1595: if fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_debug_medium ) then
1596: fnd_message.set_name ('JTF', 'JTF_EC_ERROR');
1597: fnd_msg_pub.Add;
1598: RAISE fnd_api.g_exc_error;
1599: end if;
1600: end if;
1601: close c_esc_old_level;
1602:

Line 1693: IF FND_API.To_Boolean( p_commit ) THEN

1689: set workflow_process_id = l_itemkey
1690: where task_id = p_task_id;
1691:
1692: -- Standard check of p_commit.
1693: IF FND_API.To_Boolean( p_commit ) THEN
1694: COMMIT WORK;
1695: END IF;
1696:
1697: x_notif_not_sent := g_notif_not_sent;

Line 1706: WHEN fnd_api.g_exc_error

1702: );
1703:
1704: EXCEPTION
1705:
1706: WHEN fnd_api.g_exc_error
1707: THEN
1708: ROLLBACK TO Start_Resc_Workflow;
1709: x_return_status := fnd_api.g_ret_sts_error;
1710: fnd_msg_pub.count_and_get (

Line 1709: x_return_status := fnd_api.g_ret_sts_error;

1705:
1706: WHEN fnd_api.g_exc_error
1707: THEN
1708: ROLLBACK TO Start_Resc_Workflow;
1709: x_return_status := fnd_api.g_ret_sts_error;
1710: fnd_msg_pub.count_and_get (
1711: p_count => x_msg_count,
1712: p_data => x_msg_data
1713: );

Line 1715: WHEN fnd_api.g_exc_unexpected_error

1711: p_count => x_msg_count,
1712: p_data => x_msg_data
1713: );
1714:
1715: WHEN fnd_api.g_exc_unexpected_error
1716: THEN
1717: ROLLBACK TO Start_Resc_Workflow;
1718:
1719: -- get the WF error stack

Line 1736: x_return_status := fnd_api.g_ret_sts_unexp_error;

1732: fnd_message.set_token('ERROR_STACK', l_errstack);
1733: fnd_msg_pub.add;
1734: end if;
1735:
1736: x_return_status := fnd_api.g_ret_sts_unexp_error;
1737: FND_MSG_PUB.Add_Exc_Msg
1738: (G_PKG_NAME,
1739: l_api_name
1740: );

Line 1749: x_return_status := fnd_api.g_ret_sts_unexp_error;

1745:
1746: WHEN OTHERS
1747: THEN
1748: ROLLBACK TO Start_Resc_Workflow;
1749: x_return_status := fnd_api.g_ret_sts_unexp_error;
1750: if FND_MSG_PUB.Check_Msg_Level
1751: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1752: then
1753: FND_MSG_PUB.Add_Exc_Msg

Line 2147: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN

2143: P_OLD_TARGET_DATE =>NULL,
2144: x_notif_not_sent =>l_notif_not_sent,
2145: X_WF_PROCESS_ID =>l_wf_process_id);
2146:
2147: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
2148: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'create_esc_notif_subs', p_event.event_name, p_subscription_guid);
2149: wf_event.seterrorinfo(p_event, 'WARNING');
2150: RETURN 'WARNING';
2151: END IF;

Line 2208: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN

2204: P_OLD_TARGET_DATE =>l_esc_rec.old_target_date,
2205: x_notif_not_sent =>l_notif_not_sent,
2206: X_WF_PROCESS_ID =>l_wf_process_id);
2207:
2208: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
2209: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'update_esc_notif_subs', p_event.event_name, p_subscription_guid);
2210: wf_event.seterrorinfo(p_event, 'WARNING');
2211: RETURN 'WARNING';
2212: END IF;