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.CSP_REPAIR_PO_GRP dependencies on FND_MESSAGE

Line 136: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_DEFECTIVE_QUANTITY');

132: Select MTL_DEMAND_S.NEXTVAL INTO l_demand_source_line_id FROM DUAL;
133: l_reservation_rec.line_id := l_demand_source_line_id;
134:
135: If l_defective_parts_rec.defective_quantity <= 0 then
136: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_DEFECTIVE_QUANTITY');
137: FND_MSG_PUB.ADD;
138: RAISE EXCP_USER_DEFINED;
139: End if;
140:

Line 153: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_DEFECTORG');

149: ,x_msg_count
150: );
151: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
152: L_SOURCE_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_source_organization_id);
153: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_DEFECTORG');
154: FND_MESSAGE.SET_TOKEN ('DEFECTIVE_ORG_NAME', L_SOURCE_ORGANIZATION_NAME,TRUE);
155: FND_MSG_PUB.ADD;
156: RAISE EXCP_USER_DEFINED;
157: END IF;

Line 154: FND_MESSAGE.SET_TOKEN ('DEFECTIVE_ORG_NAME', L_SOURCE_ORGANIZATION_NAME,TRUE);

150: );
151: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
152: L_SOURCE_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_source_organization_id);
153: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_DEFECTORG');
154: FND_MESSAGE.SET_TOKEN ('DEFECTIVE_ORG_NAME', L_SOURCE_ORGANIZATION_NAME,TRUE);
155: FND_MSG_PUB.ADD;
156: RAISE EXCP_USER_DEFINED;
157: END IF;
158:

Line 171: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');

167: ,x_msg_count
168: );
169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
170: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
171: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
172: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_REPAIR_ORGANIZATION_NAME,TRUE);
173: FND_MSG_PUB.ADD;
174: RAISE EXCP_USER_DEFINED;
175: END IF;

Line 172: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_REPAIR_ORGANIZATION_NAME,TRUE);

168: );
169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
170: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
171: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
172: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_REPAIR_ORGANIZATION_NAME,TRUE);
173: FND_MSG_PUB.ADD;
174: RAISE EXCP_USER_DEFINED;
175: END IF;
176:

Line 248: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_REPAIR_SUPPLIER');

244: and NVL(START_DATE_ACTIVE,SYSDATE) <= SYSDATE
245: and NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE;
246: Exception
247: When No_Data_Found then
248: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_REPAIR_SUPPLIER');
249: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ID',to_char(P_repair_supplier_id), TRUE);
250: FND_MSG_PUB.ADD;
251: RAISE EXCP_USER_DEFINED;
252: End;

Line 249: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ID',to_char(P_repair_supplier_id), TRUE);

245: and NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE;
246: Exception
247: When No_Data_Found then
248: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_REPAIR_SUPPLIER');
249: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ID',to_char(P_repair_supplier_id), TRUE);
250: FND_MSG_PUB.ADD;
251: RAISE EXCP_USER_DEFINED;
252: End;
253:

Line 266: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');

262: where ORG_INFORMATION_CONTEXT = 'Customer/Supplier Association'
263: and ORG_INFORMATION3 = P_repair_supplier_id; ---> 1159 (Vendor Id parameter)
264: Exception
265: When No_Data_Found then
266: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
267: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', l_VENDOR_NAME, TRUE);
268: --(OR) No organization is linked with the repair supplier Id.
269: FND_MSG_PUB.ADD;
270: RAISE EXCP_USER_DEFINED;

Line 267: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', l_VENDOR_NAME, TRUE);

263: and ORG_INFORMATION3 = P_repair_supplier_id; ---> 1159 (Vendor Id parameter)
264: Exception
265: When No_Data_Found then
266: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
267: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', l_VENDOR_NAME, TRUE);
268: --(OR) No organization is linked with the repair supplier Id.
269: FND_MSG_PUB.ADD;
270: RAISE EXCP_USER_DEFINED;
271: End;

Line 300: FND_MESSAGE.SET_NAME ('CSP','CSP_MISSING_PARAMETERS');

296: and NVL(a.START_DATE_ACTIVE,SYSDATE) <= SYSDATE
297: and NVL(a.END_DATE_ACTIVE,SYSDATE) >= SYSDATE;
298: Exception
299: When no_data_found then
300: FND_MESSAGE.SET_NAME ('CSP','CSP_MISSING_PARAMETERS');
301: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'Repair Supplier ID cannot be null', TRUE);
302: FND_MSG_PUB.ADD;
303: RAISE EXCP_USER_DEFINED;
304: End;

Line 301: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'Repair Supplier ID cannot be null', TRUE);

297: and NVL(a.END_DATE_ACTIVE,SYSDATE) >= SYSDATE;
298: Exception
299: When no_data_found then
300: FND_MESSAGE.SET_NAME ('CSP','CSP_MISSING_PARAMETERS');
301: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'Repair Supplier ID cannot be null', TRUE);
302: FND_MSG_PUB.ADD;
303: RAISE EXCP_USER_DEFINED;
304: End;
305: */

Line 322: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_REPAIR_PROGRAM');

318: and NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE
319: and lookup_code = p_repair_program;
320: Exception
321: When no_data_found then
322: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_REPAIR_PROGRAM');
323: FND_MSG_PUB.ADD;
324: RAISE EXCP_USER_DEFINED;
325: End;
326:

Line 338: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');

334:
335: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
336:
337: If L_REPAIR_ORGANIZATION_NAME is null then
338: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
339: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', l_VENDOR_NAME, TRUE);
340: --(OR) No organization is linked with the repair supplier Id.
341: FND_MSG_PUB.ADD;
342: RAISE EXCP_USER_DEFINED;

Line 339: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', l_VENDOR_NAME, TRUE);

335: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
336:
337: If L_REPAIR_ORGANIZATION_NAME is null then
338: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
339: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', l_VENDOR_NAME, TRUE);
340: --(OR) No organization is linked with the repair supplier Id.
341: FND_MSG_PUB.ADD;
342: RAISE EXCP_USER_DEFINED;
343:

Line 356: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_REPAIRORG');

352: ,x_msg_data
353: ,x_msg_count
354: );
355: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
356: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_REPAIRORG');
357: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_REPAIR_ORGANIZATION_NAME,TRUE);
358: FND_MSG_PUB.ADD;
359: RAISE EXCP_USER_DEFINED;
360: END IF;

Line 357: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_REPAIR_ORGANIZATION_NAME,TRUE);

353: ,x_msg_count
354: );
355: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
356: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_REPAIRORG');
357: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_REPAIR_ORGANIZATION_NAME,TRUE);
358: FND_MSG_PUB.ADD;
359: RAISE EXCP_USER_DEFINED;
360: END IF;
361:

Line 370: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPFROM_LOCATION_ID');

366: WHERE ORGANIZATION_ID = nvl(P_repair_supplier_org_id,L_repair_supplier_org_id);
367: Exception
368: When no_data_found then
369: --l_supplier_org_location_id := Null;
370: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPFROM_LOCATION_ID');
371: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);
372: FND_MSG_PUB.ADD;
373: RAISE EXCP_USER_DEFINED;
374: End;

Line 371: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);

367: Exception
368: When no_data_found then
369: --l_supplier_org_location_id := Null;
370: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPFROM_LOCATION_ID');
371: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);
372: FND_MSG_PUB.ADD;
373: RAISE EXCP_USER_DEFINED;
374: End;
375:

Line 383: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_DEST_ORG');

379: a customer must be associated with this location in Purchasing*/
380:
381: L_DEST_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_dest_organization_id);
382: If L_DEST_ORGANIZATION_NAME is null then
383: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_DEST_ORG');
384: FND_MESSAGE.SET_TOKEN ('DEST_ORG_ID', to_char(P_dest_organization_id), TRUE);
385: FND_MSG_PUB.ADD;
386: RAISE EXCP_USER_DEFINED;
387: Elsif L_DEST_ORGANIZATION_NAME is not null then

Line 384: FND_MESSAGE.SET_TOKEN ('DEST_ORG_ID', to_char(P_dest_organization_id), TRUE);

380:
381: L_DEST_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_dest_organization_id);
382: If L_DEST_ORGANIZATION_NAME is null then
383: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_DEST_ORG');
384: FND_MESSAGE.SET_TOKEN ('DEST_ORG_ID', to_char(P_dest_organization_id), TRUE);
385: FND_MSG_PUB.ADD;
386: RAISE EXCP_USER_DEFINED;
387: Elsif L_DEST_ORGANIZATION_NAME is not null then
388:

Line 400: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_DESTORG');

396: ,x_msg_data
397: ,x_msg_count
398: );
399: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
400: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_DESTORG');
401: FND_MESSAGE.SET_TOKEN ('DEST_ORG_NAME', L_DEST_ORGANIZATION_NAME,TRUE);
402: FND_MSG_PUB.ADD;
403: RAISE EXCP_USER_DEFINED;
404: END IF;

Line 401: FND_MESSAGE.SET_TOKEN ('DEST_ORG_NAME', L_DEST_ORGANIZATION_NAME,TRUE);

397: ,x_msg_count
398: );
399: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
400: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_DESTORG');
401: FND_MESSAGE.SET_TOKEN ('DEST_ORG_NAME', L_DEST_ORGANIZATION_NAME,TRUE);
402: FND_MSG_PUB.ADD;
403: RAISE EXCP_USER_DEFINED;
404: END IF;
405:

Line 414: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPTO_LOCATION_ID');

410: WHERE ORGANIZATION_ID = P_dest_organization_id;
411: Exception
412: When no_data_found then
413: --l_ship_to_location_id := Null;
414: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPTO_LOCATION_ID');
415: FND_MESSAGE.SET_TOKEN ('DESTINATION_ORG', L_DEST_ORGANIZATION_NAME, TRUE);
416: FND_MSG_PUB.ADD;
417: RAISE EXCP_USER_DEFINED;
418: End;

Line 415: FND_MESSAGE.SET_TOKEN ('DESTINATION_ORG', L_DEST_ORGANIZATION_NAME, TRUE);

411: Exception
412: When no_data_found then
413: --l_ship_to_location_id := Null;
414: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPTO_LOCATION_ID');
415: FND_MESSAGE.SET_TOKEN ('DESTINATION_ORG', L_DEST_ORGANIZATION_NAME, TRUE);
416: FND_MSG_PUB.ADD;
417: RAISE EXCP_USER_DEFINED;
418: End;
419: End if;

Line 435: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFAULT_SHIPPING_METHOD');

431: Exception
432: When no_data_found then
433: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
434: L_DEST_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_dest_organization_id);
435: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFAULT_SHIPPING_METHOD');
436: FND_MESSAGE.SET_TOKEN ('FROM_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);
437: FND_MESSAGE.SET_TOKEN ('TO_ORG', L_DEST_ORGANIZATION_NAME, TRUE);
438: FND_MSG_PUB.ADD;
439: RAISE EXCP_USER_DEFINED;

Line 436: FND_MESSAGE.SET_TOKEN ('FROM_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);

432: When no_data_found then
433: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
434: L_DEST_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_dest_organization_id);
435: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFAULT_SHIPPING_METHOD');
436: FND_MESSAGE.SET_TOKEN ('FROM_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);
437: FND_MESSAGE.SET_TOKEN ('TO_ORG', L_DEST_ORGANIZATION_NAME, TRUE);
438: FND_MSG_PUB.ADD;
439: RAISE EXCP_USER_DEFINED;
440: End;

Line 437: FND_MESSAGE.SET_TOKEN ('TO_ORG', L_DEST_ORGANIZATION_NAME, TRUE);

433: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
434: L_DEST_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_dest_organization_id);
435: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFAULT_SHIPPING_METHOD');
436: FND_MESSAGE.SET_TOKEN ('FROM_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);
437: FND_MESSAGE.SET_TOKEN ('TO_ORG', L_DEST_ORGANIZATION_NAME, TRUE);
438: FND_MSG_PUB.ADD;
439: RAISE EXCP_USER_DEFINED;
440: End;
441: else

Line 445: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_REPAIRPO_NEED_QTY');

441: else
442: l_shipping_method_code := p_shipping_method;
443: end if ;
444: If nvl(P_quantity,0) <= 0 then
445: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_REPAIRPO_NEED_QTY');
446: FND_MSG_PUB.ADD;
447: RAISE EXCP_USER_DEFINED;
448: End if;
449:

Line 451: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_REPAIRPO_NEED_DATE');

447: RAISE EXCP_USER_DEFINED;
448: End if;
449:
450: If trunc(nvl(P_need_by_date,sysdate)) <= trunc(sysdate) then
451: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_REPAIRPO_NEED_DATE');
452: FND_MSG_PUB.ADD;
453: RAISE EXCP_USER_DEFINED;
454: End if;
455:

Line 764: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

760: ,X_MSG_DATA => X_MSG_DATA
761: ,X_RETURN_STATUS => X_RETURN_STATUS);
762: WHEN OTHERS THEN
763: Rollback to CREATE_REPAIR_PO_PUB;
764: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
765: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
766: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
767: FND_MSG_PUB.ADD;
768: fnd_msg_pub.count_and_get

Line 765: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

761: ,X_RETURN_STATUS => X_RETURN_STATUS);
762: WHEN OTHERS THEN
763: Rollback to CREATE_REPAIR_PO_PUB;
764: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
765: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
766: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
767: FND_MSG_PUB.ADD;
768: fnd_msg_pub.count_and_get
769: (p_count => x_msg_count

Line 766: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

762: WHEN OTHERS THEN
763: Rollback to CREATE_REPAIR_PO_PUB;
764: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
765: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
766: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
767: FND_MSG_PUB.ADD;
768: fnd_msg_pub.count_and_get
769: (p_count => x_msg_count
770: ,p_data => x_msg_data);

Line 834: FND_MESSAGE.SET_NAME('CSP','CSP_UNEXPECTED_EXEC_ERRORS');

830: x_return_status := FND_API.G_RET_STS_ERROR;
831: END IF;
832: EXCEPTION
833: WHEN OTHERS THEN
834: FND_MESSAGE.SET_NAME('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
835: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
836: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
837: FND_MSG_PUB.ADD;
838: fnd_msg_pub.count_and_get

Line 835: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

831: END IF;
832: EXCEPTION
833: WHEN OTHERS THEN
834: FND_MESSAGE.SET_NAME('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
835: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
836: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
837: FND_MSG_PUB.ADD;
838: fnd_msg_pub.count_and_get
839: (p_count => x_msg_count

Line 836: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

832: EXCEPTION
833: WHEN OTHERS THEN
834: FND_MESSAGE.SET_NAME('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
835: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
836: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
837: FND_MSG_PUB.ADD;
838: fnd_msg_pub.count_and_get
839: (p_count => x_msg_count
840: ,p_data => x_msg_data);