APPS.PA_PLANNING_RESOURCE_UTILS dependencies on FND_NEW_MESSAGES

Line 360: -- l_error_msg_data fnd_new_messages.message_name%TYPE;

356: IS
357: --Declaration of Local variables
358: -- l_return_status VARCHAR2(1);
359: l_organization_id NUMBER := null;
360: -- l_error_msg_data fnd_new_messages.message_name%TYPE;
361: BEGIN
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363: x_error_msg_code := Null;
364: -- validate the organization and assign the id to the global record.

Line 558: l_error_msg_code fnd_new_messages.message_name%TYPE;

554: x_error_msg_code OUT NOCOPY VARCHAR2)
555:
556: IS
557: l_return_status VARCHAR2(1);
558: l_error_msg_code fnd_new_messages.message_name%TYPE;
559: l_supplier_id PO_VENDORS.vendor_id%TYPE := NULL;
560: l_err_status VARCHAR2(30) := 'N';
561: /************************************************************************
562: * Sub-function : Is_Contingent_Worker

Line 973: l_error_msg_data fnd_new_messages.message_name%TYPE;

969: l_current_id NUMBER := NULL;
970: l_num_ids NUMBER := 0;
971: l_id_found_flag VARCHAR(1) := 'N';
972: l_return_status VARCHAR2(1);
973: l_error_msg_data fnd_new_messages.message_name%TYPE;
974:
975: CURSOR c_ids IS
976: SELECT b.resource_id
977: FROM bom_resources b

Line 1107: l_error_msg_data fnd_new_messages.message_name%TYPE;

1103: l_current_id NUMBER := NULL;
1104: l_num_ids NUMBER := 0;
1105: l_id_found_flag VARCHAR(1) := 'N';
1106: l_return_status VARCHAR2(1);
1107: l_error_msg_data fnd_new_messages.message_name%TYPE;
1108:
1109: CURSOR c_ids IS
1110: SELECT c.category_id
1111: FROM mtl_categories_b c, mtl_category_set_valid_cats I

Line 1231: l_error_msg_data fnd_new_messages.message_name%TYPE;

1227: l_current_id NUMBER := NULL;
1228: l_num_ids NUMBER := 0;
1229: l_id_found_flag VARCHAR(1) := 'N';
1230: l_return_status VARCHAR2(1);
1231: l_error_msg_data fnd_new_messages.message_name%TYPE;
1232:
1233: /********************************************
1234: * Bug - 3566965
1235: * Desc - Modified the cursor to select based on