APPS.PA_PLANNING_RESOURCE_UTILS dependencies on FND_NEW_MESSAGES

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

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

Line 562: l_error_msg_code fnd_new_messages.message_name%TYPE;

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

Line 977: l_error_msg_data fnd_new_messages.message_name%TYPE;

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

Line 1111: l_error_msg_data fnd_new_messages.message_name%TYPE;

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

Line 1235: l_error_msg_data fnd_new_messages.message_name%TYPE;

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