DBA Data[Home] [Help]

APPS.CN_NOTIFY_ORDERS dependencies on STANDARD

Line 379: -- and 'Standard' lines which do not have their own sales credits.

375: --+
376: IF p_line_id IS NULL THEN
377: --+
378: -- This is a Header Sales Credit, so recollect any Top Model Lines
379: -- and 'Standard' lines which do not have their own sales credits.
380: -- Do this using a recursive self-call, so that any children of
381: -- these lines, which do not have their own sales credits, will
382: -- also be re-collected.
383: --+

Line 426: -- If this is a 'Standard' line then also re-collect any Service

422: cn_message_pkg.debug('notify: adjust: .. Serv/Conf line');
423: fnd_file.put_line(fnd_file.Log, 'notify: adjust: .. Serv/Conf line');
424: NULL;
425: --+
426: -- If this is a 'Standard' line then also re-collect any Service
427: -- Lines belonging to this line, which do not have their own
428: -- direct sales credits.
429: -- Note: Service Lines can be on a different order
430: --+

Line 433: cn_message_pkg.debug('notify: adjust: .. Standard line');

429: -- Note: Service Lines can be on a different order
430: --+
431: ELSIF l_line_rec.service_reference_line_id IS NULL
432: AND l_line_rec.top_model_line_id IS NULL THEN
433: cn_message_pkg.debug('notify: adjust: .. Standard line');
434: fnd_file.put_line(fnd_file.Log, 'notify: adjust: .. Standard line');
435: FOR rec IN
436: (SELECT header_id, line_id
437: FROM aso_i_oe_order_lines_v asol

Line 434: fnd_file.put_line(fnd_file.Log, 'notify: adjust: .. Standard line');

430: --+
431: ELSIF l_line_rec.service_reference_line_id IS NULL
432: AND l_line_rec.top_model_line_id IS NULL THEN
433: cn_message_pkg.debug('notify: adjust: .. Standard line');
434: fnd_file.put_line(fnd_file.Log, 'notify: adjust: .. Standard line');
435: FOR rec IN
436: (SELECT header_id, line_id
437: FROM aso_i_oe_order_lines_v asol
438: WHERE asol.service_reference_line_id = p_line_id

Line 565: -- Standard Start of API savepoint

561:
562: cn_message_pkg.debug('notify: Entering adjust_order (hid = '||p_header_id||') ');
563: fnd_file.put_line(fnd_file.Log, 'notify: Entering adjust_order (hid = '||p_header_id||') ');
564:
565: -- Standard Start of API savepoint
566: SAVEPOINT Update_Headers;
567: -- Standard call to check for call compatibility.
568: IF NOT FND_API.Compatible_API_Call (l_api_version,
569: p_api_version,

Line 567: -- Standard call to check for call compatibility.

563: fnd_file.put_line(fnd_file.Log, 'notify: Entering adjust_order (hid = '||p_header_id||') ');
564:
565: -- Standard Start of API savepoint
566: SAVEPOINT Update_Headers;
567: -- Standard call to check for call compatibility.
568: IF NOT FND_API.Compatible_API_Call (l_api_version,
569: p_api_version,
570: l_api_name,
571: G_PKG_NAME)

Line 902: -- Standard check of p_commit.

898: cn_message_pkg.end_batch(l_process_audit_id);
899: -------------------+
900: -- End of API body.
901: -------------------+
902: -- Standard check of p_commit.
903: IF FND_API.To_Boolean( p_commit ) THEN
904: COMMIT WORK;
905: END IF;
906: -- Standard call to get message count and if count is 1, get message info.

Line 906: -- Standard call to get message count and if count is 1, get message info.

902: -- Standard check of p_commit.
903: IF FND_API.To_Boolean( p_commit ) THEN
904: COMMIT WORK;
905: END IF;
906: -- Standard call to get message count and if count is 1, get message info.
907: FND_MSG_PUB.Count_And_Get
908: (p_count => x_msg_count ,
909: p_data => x_msg_data ,
910: p_encoded => FND_API.G_FALSE);

Line 1030: -- Standard Start of process savepoint

1026:
1027: l_org_id NUMBER;
1028:
1029: BEGIN
1030: -- Standard Start of process savepoint
1031: SAVEPOINT Update_Headers_Savepoint;
1032:
1033: l_org_id := x_org_id;
1034:

Line 1039: -- Queue savepoint for standard advanced queue error handling

1035: --+
1036: -- Start looping to check for messages in the queue
1037: --+
1038: LOOP
1039: -- Queue savepoint for standard advanced queue error handling
1040: SAVEPOINT Get_Notice_Loop_Savepoint;
1041: --+
1042: -- Invoke Get_Notice to dequeue queue payload and return Order data
1043: --+